[TYPO3-realty] Static SQL-Filter

[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
-- 
Certified TYPO3 Integrator | TYPO3 Security Team Member