[TYPO3] Joining tables with Typo-Script

[JoH]

>>> 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:
>>
http://lists.netfielders.de/pipermail/typo3-german/2006-February/011679.html
>
> 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.

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: http://www.cybercraft.de