[TYPO3] Joining tables with Typo-Script

[JoH]

> I've tried this and again it's not fully functional.
>
> L=0 or nothing is German
> L=2 is english
>
> Opening my page with &L=2, I see only english content-elements, as
> expected. But all other combinations only return an empty site.
>
> Whats wrong?
>
> My TypoScript:
> page.10.marks.CONTENT= COA
> page.10.marks.CONTENT {
>     10 = CONTENT
>     10 {
>         table = tt_content
>         select {
>             andWhere.dataWrap = sys_language_uid={GPvar:L}
>             andWhere.if.isTrue.data = GPvar:L
>             orderBy = sorting
>         }
>     }
>     20  = CONTENT
>     20 {
>         table = pages
>         select {
>             orderBy = sorting
>         }
>         renderObj = CONTENT
>         renderObj {
>             table = tt_content
>             select {
>                andWhere.dataWrap = sys_language_uid={GPvar:L}
>                andWhere.if.isTrue.data = GPvar:L
>                pidInList.field = uid
>                orderBy = sorting
>            }
>         }
>     }
> }

Try removing andWhere.if....
And check if you are setting the sys_language_uid for both cases:
1. if the L parameter is zero
2. if the L parameter is empty

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