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

Mon Mar 19 21:34:20 CET 2012

Hi,

now I got the correct uid from the database, but I don't know how to
generate a body tag with the uid as ID.

temp.cat = CONTENT
temp.cat {
  table = tx_cagrelatedcontent_category
  select {
    pidInList = 14
    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.field = uid
  }
}

One way would be putting the raw uid into the body tag (<body
id="cat_1">) but I need a CASE or globalVar there to put a more
descriptive text as an ID.

Can I integrade a CASE inside the CONTENT object?

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