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

Peter Russ peter.russ at 4many.net
Fri Jan 15 12:47:52 CET 2010


--- Original Nachricht ---
Absender:   Henjo Hoeksma
Datum:       15.01.2010 12:30:
> 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.

Because TS doesn't know how to handle that ;-)
andWhere is either string OR stdWrap. Due to () you assign a string.
Solution:make all stdWrap

andWhere.data=GP:tx_flexproducts_pi1|showUid
andWhere.wrap(
   tx_flexproducts_products_faq_rel.faqid = tx_flexproducts_faq.uid AND
   tx_flexproducts_products_faq_rel.productid IN (|)
)


-- 
loans that change lives http://www.kiva.org

_____________________________
uon GbR
http://www.uon.li
http://www.xing.com/profile/Peter_Russ


More information about the TYPO3-english mailing list