in reply to How to use template toolkit variable in a template toolkit mysql query

My TT-foo is a bit rusty, but I think you cannot nest [% ... %] clauses.

Did you try building the SQL string outside of the FOREACH loop and saving it in a variable and then using that variable as a parameter of the DBI.prepare?

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

Replies are listed 'Best First'.
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

    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.

[reply]
[d/l]
      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]
        No, tried it myself :(
[reply]

In Section Seekers of Perl Wisdom