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

[Peter Niederlag]

Hi,

Stefan Ernst schrieb:
> (I've also posted this in the Typo3-English list, but I'm not sure if
> this one here is the more appropriate one, apologies if I annoyed
> someone with this)
[...]
> marks.INHALT = CONTENT
> marks.INHALT {
>   table = tt_content
>   select.pidInList = this

you should not need this ^^

>   select.orderBy = sorting
> }
> }
> 
> [minute =
> 0,2,4,6,8,10,12,14,16,18,20,22,24,26,28,30,32,34,36,38,40,42,44,46,48,50,52,54,56,58]
> 
> 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

Greets,
Peter
-- 
Peter Niederlag
http://www.niekom.de * TYPO3 & EDV Dienstleistungen *
http://www.typo3partner.net * professional services network *