[TYPO3] Joining tables with Typo-Script

[JoH]

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

Maybe this one can do a better job:

select {
    languageField = sys_language_uid
    orderBy = sorting
}

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