[TYPO3-english] select in TS with conditions

[Jigal van Hemert]

Hi,

On 13-8-2012 8:57, Piotr Burda wrote:
> i have this code
>
>    [globalVar = global:HTTP_POST_VARS|rent-a-car|get_car = Katowice]
>    get_carpid = TEXT
>    get_carpid.value = 27
>    [global]
>
> and this select
>            markers.master_input_wart = CONTENT
>            markers.master_input_wart {
>              table = tx_pbjokapricelist_prices_full
>              select {
>                pidInList = get_carpid
                  pidInList = ###carpid###
>                orderBy = uid
>                selectFields = uid, group_a_1_3
>                # possible conditions
>                 where = ( tx_pbjokapricelist_prices_full.uid='1' AND
> hidden='0' AND deleted='0')

                  markers {
                    carpid.cObject < get_carpid
                  }

>              }
>              renderObj = COA
>              renderObj {
>                #value
>                1 = TEXT
>                1.insertData = 1
>                1.data = field:group_a_1_3
>                2 = TEXT
>                2.value = *
>                3 = TEXT
>                3.insertData = 1
>                3.data = global:HTTP_POST_VARS|rent-a-car|finish_day
>                stdWrap.prioriCalc = 1
>              }
>            }
>
> how to use defined get_carpid in SELECT in line pidInList = get_carpid

See between the code above.

-- 
Jigal van Hemert
TYPO3 Core Team member

TYPO3 .... inspiring people to share!
Get involved: typo3.org