[TYPO3-english] if.isTrue.numRows and insertData not working? [SOLVED]

Henjo Hoeksma hphoeksma at stylence.nl
Fri Jan 15 12:41:36 CET 2010


On 2010-01-15 12:30:33 +0100, Henjo Hoeksma <hphoeksma at stylence.nl> said:

> Hi list,
> 
> I have a TS statement that says the following:
> 
> 50.if.isTrue.numRows {
>     			table = tx_flexproducts_faq
>     			select {
>     				join = tx_flexproducts_products_faq_rel
>     				pidInList = {$plugin.tx_flexproducts_pi1.productsPid}
>     				where=1=1
>     				andWhere (
>     					tx_flexproducts_products_faq_rel.faqid = tx_flexproducts_faq.uid AND
>     					tx_flexproducts_products_faq_rel.productid IN 
> ({GP:tx_flexproducts_pi1|showUid})
>     				)
>     				andWhere.insertData = 1
>     				selectFields = *
>     			} 	
>     		}
> 
> When I put a uid instead of {GP:tx_flexproducts_pi1|showUid} everything 
> works as expected. Putting in the getText data item, it is not being 
> substituted resulting in a mysql error because the value is empty 
> (...IN()..).
> 
> The constant is parsed correctly.
> 
> Any clue why this is not being parsed?
> 
> Typo3 4.2.9
> 
> Thanks for your input.
> 
> Henjo


Apparently - at least in 4.2.9 - GP:... doesn't work. Using the 
deprecated GPvar:... did though...

-- 
Stylence | webdevelopment in style
www.stylence.nl



More information about the TYPO3-english mailing list