[TYPO3] DB selection form TS and WHERE

Andrea Giorgini a.giorgini at norvlit.de
Tue Nov 28 13:30:12 CET 2006


Roberto Torresani wrote:
> Hi Andrea!
> 
> try to see the page
> http://typo3.org/documentation/document-library/references/doc_core_tsref/current/view/5/5/
> 
> 
> for example you should use:
> 
> page.10.subparts.NEWS = CONTENT
> page.10.subparts.NEWS {
>  table = tt_content
>  select {
>    pidInList = 1
>    orderBy = sorting
>  }
> }
> 
> Bye
> Roberto

Ciao Roberto,

thanks for your answer but I need to extract records from tt_products. I
think CONTENT allows you to select record only from the tt_content
table, if I am right...

Andrea


More information about the TYPO3-english mailing list