[TYPO3-dev] Displaying Content Elements with custom query in the template

[Stefan Ernst]

Hello,

>> page.10.marks.INHALT.select.where =  
>> tx_ideamanorotmenu_rotation_menu=1
>> OR tx_ideamanorotmenu_rotation_menu=0 AND colPos=0
> this is just ending in
>
> select ... where uid in (xy) and foobar=12 or
> tx_ideamanorotmenu_rotation_menu=0
>
> That means you end up with an 'or' that doesn't care for the pid
>
> I would
> a) go for select.andWhere
> b) add '()' where needed to get the correct query
>
> page.10.marks.INHALT.select.andWhere =  
> (tx_ideamanorotmenu_rotation_menu=1
> OR tx_ideamanorotmenu_rotation_menu=0) AND colPos=0

Brilliant, this is exactly what I was looking for - works perfectly!

Thank you very much,
take care,

Stefan.


-- 
www.thxbye.de - Stefan Ernst's most website in the world.