[TYPO3-english] Typoscript

Siva Prasad sivaprasad.s at pitsolutions.com
Mon Dec 22 15:08:48 CET 2014


I want to execute a query using typoscript . My query is 

SELECT * FROM TABLE where  sld like '{GP:SID}'  . I want to warp the SID variable inside a  single/double quotes. Tried the below script, but didnt worked for me . 
[code]
lib.products = CONTENT
lib.products { 
    table = TABLE
    select { 
      pidInList = 26506
      orderBy = name
      where = sid like '{GP:SID}'
     } 
    renderObj = COA
    renderObj { 
      10  = COA
      10  { 
      	10= TEXT
        10.dataWrap ={field:name}[\n] 
      } 
    } 
  }
[code]
Can any help me with this ?


More information about the TYPO3-english mailing list