[TYPO3-dev] strange enableFields SQL with T3 4.0

Jan-Hendrik Heuing [DD] jh at digitaldistrict.de
Wed Apr 12 01:12:14 CEST 2006


Hi!

Just had a look at the new version including some PHP, I stumbled across 
some strange SQL. Well, it is working, but it could be much simpler if I am 
right...

....(tx_ddblog_entries.fe_group LIKE '%,-2,%' OR tx_ddblog_entries.fe_group 
LIKE '-2,%' OR tx_ddblog_entries.fe_group LIKE '%,-2' OR 
tx_ddblog_entries.fe_group='-2')...

Some CONCAT statement should do that all at once, before I submit some 
changes, is there any reason why it is done this way?

JH 






More information about the TYPO3-dev mailing list