TYPO3 Core

things like andWhere = CType IS IN LIST ('html','text') don't work either

I did a quick test on my site using the following code:

page.20 = CONTENT
page.20.table = tt_content
page.20.select {
pidInList = this
orderBy = sorting
where = colPos=0
andWhere = header <> ''
languageField = sys_language_uid
}

And this give the expended result, no error and some data on the website.
This was tested with DBAL from SVN.

Ries

Hi,

I confirm that I could not reproduce the issue as stated in the description with DBAL-trunk. SQL parser has been much improved lately and as such, the problem seems to have been solved automatically.

In your note from 06.03.09, you say that

andWhere = CType IS IN LIST

does not work either. This should be

andWhere = CType IN ('html', 'text')

I did not tested this andWhere clause but I fixed IN keyword support recently and as such it should work as well. I will test this case and if it works set this bug to resolved without any change needed.

Xavier,

the given IN clause by Mangan was indeed correct, however I think the most important part was teh first item and that is solved now.

Ries

Well, I don't see any "IS IN LIST" operator on
http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html

Anyway, using

andWhere = CType IN ('html', 'text')

is supported, I just tested it. Gonna close this bug.