[TYPO3-english] Add ID to body tag depends on DB value

[Stefano Kowalke]

The result I get with this query in MySQl is just the id of the category
not the name itself. IMO I need the join, because without there is no
connection between the page table and the category table.

Correct me if I am wrong.

Could you post here the part of renderObj. I don't get it.
Do I have assign temp.category to a page object or a marker?

Stefano

Am 15.03.12 23:13, schrieb Urs Bräm:
> Hi Stefano
> 
> to simplify for debug, you could first go only fo the category uid, and
> set the number (with a prefix) into the body tag, like id="cat0", so you
> get rid of the join. Maybe that's even more robust. If that works, you
> can still add the join to spell out the category name later.
> 
> Regards
> Urs
> 
> 
> 
> 
> 
> 
> 
> Am 15.03.12 20:47, schrieb Stefano Kowalke:
>> Am 15.03.12 17:35, schrieb Philipp Gampe:
>>>> temp.category = CONTENT
>>>>> temp.category {
>>>>>    table = tx_cagrelatedcontent_category
>>>>>    select {
>>>>>      selectFields = tx_cagrelatedcontent_category.uid
>>>>>      join = pages_tx_cagrelatedcontent_category_mm
>>>>>      where = tx_cagrelatedcontent_category.uid =
>>>>> pages_tx_cagrelatedcontent_category_mm.uid_foreign
>>>>>      andWhere = pages_tx_cagrelatedcontent_category_mm.uid_local =
>>>>>      {page:uid} andWhere.insertData = 1
>>>>>    }
>>>>>
>>>>>    renderObj = COA
>>>>>    renderObj {
>>>>>      10 = TEXT
>>>>>      10 {
>>>>>        required = 1
>>> Try dataWrap = debug:data here.
>>
>>
>> Ok tried this (with page.config.debug = 1). But nothing happend. Should
>> I see an output?
>>
>> Does this query work in phpmyadmin?
>>
>> Yes, it does.
>>
>> Stefano
>>
>>
> 
>