[TYPO3] Joining tables with Typo-Script

JoH info at cybercraft.de
Sun Mar 5 15:51:18 CET 2006

>>> I'm searching for a solution for the following problem:
>>> I want to create a page on which the content-elements of it's
>>> subpage are shown. I've tried it with the following Typo3-code, but
>>> it's not working. I've no clue what could be wrong.
>> Have a look at this thread:
> Thanks for your help. Now, I get too much ;). I get german and english
> contents at the same time. How can I fix this?

Assuming you trigger the languages with the URL-paremeter "L" one option you
got with TS will be this:

select {
    orderBy = sorting
    andWhere.dataWrap = sys_language_uid={GPvar:L}
    andWhere.if.isTrue.data = GPvar:L

Put it into the select part for tt_content but _not_ for pages.


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

More information about the TYPO3-english mailing list