[Typo3] RE: Taking a value from an URL

[JoH]

> We were able to get the example working except, we still can't take the
> value from the url, for example &tx_svdgbseminar_pi1[showUid]=555
> and insert it into the select field select.where = member_id='555' so if
the
> value is 556 it should be placed automatically be inserted into the
> select.where = member_id='|'
>
>
> tt_content.list.20.0 >
> tt_content.list.20.0 = CASE
> tt_content.list.20.0.key.field = layout
> tt_content.list.20.0.0 = CONTENT
> tt_content.list.20.0.0 {
>   table = tx_memberprofile_member
>   select.orderBy = first_name
>   select.pidInList.field = pages
>    select.where = member_id='555'
>
>
> }
>
>  Any ideas?

TSref says: select.where has no stdWrap properties but select.andWhere has.

So you can do the following

tt_content.list.20.0.0 = CONTENT
tt_content.list.20.0.0 {
   table = tx_memberprofile_member
   select.orderBy = first_name
   select.pidInList.field = pages
    select.andWhere.data = GPvar : stuff
    select.andWhere.wrap = uid='|'
}

or even more

tt_content.list.20.0.0 = CONTENT
tt_content.list.20.0.0 {
   table = tx_memberprofile_member
   select.orderBy = first_name
   select.pidInList.field = pages
    select.andWhere.cObject = COA
    select.andWhere.cObject  {
        10 = TEXT
        10.data = GPvar : stuff
        10.noTrimWrap = |uid='|' AND|

        20 = TEXT
        20.data = GPvar : otherstuff
        20.noTrimWrap = | pid='|' AND|

        30 = TEXT
        30.data = GPvar : otherstuff
        30.noTrimWrap = | whatever='|'|
}

Got it?

Joey