[TYPO3] select.where - Problem

Frederic Gaus mailinglists at necroshine.de
Tue Mar 7 17:26:21 CET 2006


Hi guys,

I'm trying to include the contents of the subpages with newUntil >
CURRENT_DATE. I use the following TS-Code:

temp.news >
temp.news = CONTENT
temp.news {
    table = tt_content
    select.pidInList = 145
    select.languageField = sys_language_uid
    select.where = ( newUntil > CURRENT_TIME )
}

But this code-snipped is not working at all.

When I delete the select.where I get the expected contents, but
(logical) the newUntil - field is ignored.

What can I do?

Greetings

	Frederic

PS: A working SQL is:
SELECT * FROM pages WHERE pid=145 AND sys_language_uid=0 AND newUntil >
CURRENT_TIME


-- 
Frederic Gaus                                 pgp-key: 93E6903C
fingerprint: 0C55 4517 CC1E 5F7F 9059  3535 AB54 D8E8 93E6 903C



More information about the TYPO3-english mailing list