[TYPO3] select.where - Problem

[Peter Klein]

Hi Frederic. You can use the "andWhere" property, which has stdWrap 
support..

-- cut --
select.andWhere.cObject = COA
select.andWhere.cObject {
  10 = TEXT
  10.data = date:U
  10.wrap = newUntil > |
}
-- cut --

And then remove the normal "select.where"

-- 
Peter Klein/Umloud Untd

"Frederic Gaus" <mailinglists at necroshine.de> skrev i en meddelelse 
news:mailman.8740.1141748786.3122.typo3-english at lists.netfielders.de...
> 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