[TYPO3-english] select in TS with conditions

Piotr Burda pburda at typo3job.com
Mon Aug 13 08:57:45 CEST 2012


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
               orderBy = uid
               selectFields = uid, group_a_1_3
               # possible conditions
                where = ( tx_pbjokapricelist_prices_full.uid='1' AND  
hidden='0' AND deleted='0')
             }
             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

Piotr


More information about the TYPO3-english mailing list