Issue Bug Closed

#20137DBAL where clauses not handled correctly

Mangan 03/06/09, 13:46 updated 11/20/09, 21:43

Description

When you have something like

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

it works with MySQL but not with DBAL. I guess that the SQL parameters are not passed correctly. I don’t get any syntax working.

DBAL keeps telling me

Warning: Invalid argument supplied for foreach() in /cms/typo3conf/ext/dbal/class.ux_t3lib_db.php on line 966

Any ideas how to use more complex SQL queries with dbal?

(issue imported from #M10620)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.