Re^2: How to use template toolkit variable in a template toolkit mysql query

I am a afraid it does not work!

What I want to learn really is how to put a template variable in another variable. Like:

[% FOREACH row IN rows %]
[% query = "SELECT * FROM foo WHERE blah = [% row.account_code %] "%]
[% END %]
[download]

But this is not working. I did what you said as well Count0 but its not happening. Or maybe I haven't got the syntax right.

Comment on Re^2: How to use template toolkit variable in a template toolkit mysql query Download Code

Replies are listed 'Best First'.
Re^3: How to use template toolkit variable in a template toolkit mysql query by CountZero (Bishop) on May 05, 2011 at 06:18 UTC
I haven't tried it, but does this work? `[% query = "'SELECT * FROM foo WHERE blah = $row.account_code '"%]` [download] CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James	[reply] [d/l]
Re^4: How to use template toolkit variable in a template toolkit mysql query by Anonymous Monk on May 05, 2011 at 06:44 UTC
No, tried it myself :(	[reply]