[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] Wierdness when using [sql-param] values in subsequent [query] tag
Andrew McBeath wrote:
> Can someone shed light on this problem for me?
>
> I'm wanting to run an SQL statement with values obtained from a previous
> query.
> Working backwards from the obvious: ...WHERE code='[sql-param sku]'...
> which didnt work (when nested), I ended up with the following:
>
Talking to Kevin Walsh on IRC, (<plug> irc.cursor.biz, #interchange</plug>)
he pointed out that "interpolate=yes" was where I had gone wrong.
It evaluates the embedded tags first as opposed to actually in the loop.
The answer: remove the 'interpolate=yes' and the world is a happy place
again. :-)
Cheers,
Andrew
--
Andrew McBeath
System Admin / Senior Developer
Zeald Ltd
ICQ: 53879543
Ph: +64 9 4157575
Mob: +64 21 434104
-------
By ourselves we are nothing; together we are life itself. - William Horwood
-------