[TYPO3-english] Typoscript

[Richard Davies]

Hi Siva,

Drop the where and have

lib.products.select.andWhere {
>            cObject = TEXT
>            cObject {
>                data = GP:sid
>                wrap = sid like "|"
>            }
> }
>

I'm not sure whether this method is very safe. It probably isn't meant to
be used this way so theres a possibility it is open to exploitation.

Richard

On 23 December 2014 at 03:08, Siva Prasad <sivaprasad.s at pitsolutions.com>
wrote:

> 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 ?
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
>