[TYPO3-english] show the latest date

[Katja Lampela]

hi,

I have this db table (tx_klfilms_tuki) and there is the date field (tukihak_paatospvm) that I want to show with ts.

I only want to show the latest date and only once.

Here is my ts:

temp.pvm {
  10 = CONTENT
  10 {
     table = tx_klfilms_tuki
     select {
        pidInList = 226
        orderBy = tukihak_paatospvm DESC
        selectFields = tukihak_paatospvm
        max = 1
        #renderObj = TEXT   (doesn't change if I show/don't show this and following)
        #renderObj.field = tukihak_paatospvm
     }
  }
}


This doesn't give any result.



-- 
With kind regards

Katja Lampela
*Lieska-tuotanto*
www.lieska.net