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
