[TYPO3-english] Limit in statement

Tapio Markula tapio.markula at xetpoint.fi
Thu Nov 27 20:14:22 CET 2008


Hi

20 = CONTENT
     20 {
       table = tt_content
       select {
         where = colPos=0
         pidInList.field = uid
limit=1
       }


       renderObj = IMAGE
       renderObj {
         file.import=uploads/pics/
         file.import.field=image
         file.width = 270c
         #file.height = 158c
         #stdWrap.dataWrap = <td><div class="isokuva">|</div></td></tr><tr>
         #<td><div class="isokuva"><a href="index.php?id={field:uid}">
         wrap = |</a></div></td></tr><tr>
       }

the 'limit' doesn' have any effect

http://typo3.org/documentation/document-library/references/doc_core_tsref/4.1.0/view/8/9/

doesn't tell anything about limit

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


More information about the TYPO3-english mailing list