[TYPO3-project-4-3] fe_group SQL-statement, question out of curiosity

Xavier Perseguers typo3 at perseguers.ch
Sat Jun 13 16:57:20 CEST 2009


Hi,


> I'd like to know why actually the SQL statement for group-enableFields 
> contains
> this condition this way:
> 
> getMultipleGroupsWhereClause() :=
> 
> AND (pages.fe_group='' OR pages.fe_group IS NULL OR pages.fe_group='0' OR
> (pages.fe_group LIKE '%,0,%' OR pages.fe_group LIKE '0,%' OR 
> pages.fe_group LIKE
> '%,0' OR pages.fe_group='0') OR (pages.fe_group LIKE '%,-1,%' OR 
> pages.fe_group
> LIKE '-1,%' OR pages.fe_group LIKE '%,-1' OR pages.fe_group='-1'))
> 
> Is there a deeper reason, like an SQL-compatibility issue? Because this 
> can be a
> single condition (per group to check for) with 'FIND_IN_SET' and 'FIELD':

DBAL is part of core and it enables another DBMS than MySQL. For 
instance Postgres or Oracle...

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away


More information about the TYPO3-project-4-3 mailing list