[TYPO3-english] andWhere internal server error
philipp.gampe at typo3.org
Thu May 17 12:27:40 CEST 2012
Katja Lampela wrote:
> Any idea why following andWhere gives Internal Server Error (500):
> andWhere = tx_klfilms_category.UID = 16 AND tx_klfilms_film.year >=
> YEAR(CURDATE()) OR tx_klfilms_film.year = 0
> So I need the category 16 and the year field has to this or future year
> or empty year field.
I think you have an SQL error.
What does "empty year" mean? I mean what is stored in the SQL Database for
an empty year.
Check your queries via PhpMyAdmin, this should give you more meaningful
Philipp Gampe – PGP-Key 0AD96065 – TYPO3 UG Bonn/Köln
Documentation – linkvalidator
TYPO3 .... inspiring people to share!
More information about the TYPO3-english