[TYPO3-english] Limit in statement

Susanne Moog typo3 at susannemoog.de
Thu Nov 27 22:19:17 CET 2008


Tapio Markula schrieb:
> Hi
> 
> 20 = CONTENT
>     20 {
>       table = tt_content
>       select {
>         where = colPos=0
>         pidInList.field = uid
> limit=1
>       }

> purpose - I would like to fetch only the information from image field of 
> the *first* element in the col '0'

and "max" or "begin" or a combination do not help?
http://typo3.org/documentation/document-library/references/doc_core_tsref/4.1.0/view/5/5/

HTH,

Susanne


More information about the TYPO3-english mailing list