[TYPO3] DB selection form TS and WHERE

[JoH asenau]

>> 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...

Well - you are not ;-)

<quote>
table    =>    tableName
The table, the content should come from.
In standard-configurations this will be "tt_content"
NOTE: Only tables allowed are "pages" or tables prefixed with one of these:
"tt_", "tx_", "ttx_", "fe_", "user_"
</quote>

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

Joey

-- 
Wenn man keine Ahnung hat: Einfach mal Fresse halten!
(If you have no clues: simply shut your knob sometimes!)
Dieter Nuhr, German comedian
openBC/Xing: http://www.cybercraft.de
T3 cookbook: http://www.typo3experts.com