[TYPO3-realty] Static SQL-Filter

christoph Schöberl christoph_schoeb at yahoo.de
Thu Sep 16 09:25:44 CEST 2010


Am 06.09.2010 20:05, schrieb Oliver Klee:
> Hi,
>
> Am 06.09.2010 18:51, schrieb Thomas Müller:
>> Is the syntax object_type = 1 AND house_types = 3 OR house_types = 6 OR
>> house_types = 4 right ??? Or did I miss something?
>
> You probably are referring to house_type (singular).
>
> You'll need to use parenthesis because AND binds stronger than OR:
>
> (object_type = 1 AND (house_type = 3 OR house_type = 6 OR house_type = 4))
>
> Or you use IN:
>
> (object_type = 1 AND house_type IN (3,4,6))
>
>
>
> Oli

Hello i got the same Error, Did you fix the Problem ?
Regards chris


More information about the TYPO3-project-realty mailing list