[TYPO3] select.where - Problem

[Jean-Baptiste Rio]

Hi Frederic,

Frederic Gaus wrote:
> temp.news >
> temp.news = CONTENT
> temp.news {
>     table = tt_content
>     ...
>     select.where = ( newUntil > CURRENT_TIME )
> }
> 
> PS: A working SQL is:
> SELECT * FROM pages WHERE pid=145 AND sys_language_uid=0 AND newUntil >
> CURRENT_TIME
> 
>

There's a mistake in your select : you can not do a select on 
"tt_content" and have a where on "pages" fields ;)

The conversion in SQL of your CONTENT object is :
select * from tt_content where pid=145 AND sys_language_uid=0 AND 
newUntil > CURRENT_TIME

not

select * from pages where pid=145 AND sys_language_uid=0 AND newUntil > 
CURRENT_TIME

Regards,

JB