[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