[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