[TYPO3] select and parameter

Andrea Giorgini a.giorgini at norvlit.de
Fri Jan 12 11:35:26 CET 2007


Thorsten Kahler wrote:
> Hi Andrea,
>
> TS option select.where has no stdWrap properties. Use select andWhere
> instead (not tested!) and pay attention to the correct syntax of the getText
> properties (| instead of []):
> 
> select.andWhere {
> 	data = GPvar:tx_ttproducs_pi1|product
> # avoid SQL injection:
> 	intval = 1
> 	wrap = uid=|
> }
> 
> Regards
> Thorsten

Hi Thorsten,

thank you very much for the hint. So I modified like this:

temp.details = CONTENT
temp.details {
	table = tt_products
	wrap = |
	select {
		pidInList = 24,28
        	selectFields = note2
		andWhere.data = GPVar:tx_ttproducs_pi1|product
		andWhere.wrap = uid=|
		# avoid SQL injection:
		andWhere.intval = 1
        }

        renderObj=COA
  	renderObj {
		10 = TEXT
		10 {
			wrap=<div id="single_details2">|</div>
			field = note2
		}
	}
}

but still no result. Did I do something wrong or is this the result of
"not tested"? :-)

Thanks again

Andrea


More information about the TYPO3-english mailing list