Thanks Ken A.
Axel Gerstmair wrote:
Hi Ken!
On Tuesday, November 11, 2003 at 22:52, Ken Anderson wrote:
[...]
[% FOREACH monthname = DBI.query('SELECT DATE_FORMAT(NOW() + INTERVAL $count month, \'%M %Y\') as thismonth') %] [% monthname.thismonth %] [% END %]
But... $count isn't being interpolated before the query is run... Any way around this? What am I missing?
It should work if you change the single to double quotes because -- as in Perl -- single quotes are not interpolated. In your case the query string is sent unchanged to the MySQL server.
Best regards, Axel
_______________________________________________ templates mailing list [EMAIL PROTECTED] http://lists.template-toolkit.org/mailman/listinfo/templates
