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

by hamidafshar (Novice)

on May 04, 2011 at 22:44 UTC ( #903015=note: print w/ replies, xml )

Need Help??

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
Re^3: How to use template toolkit variable in a template toolkit mysql query by CountZero (Chancellor) 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]

Node Status^?

node history
Node Type: note [id://903015]
help

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others pondering the Monastery: (16)

As of 2013-06-20 10:29 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?