Jason Lewis wrote: (reformatted)
> [% FOREACH item = DBI.query(
'SELECT x FROM y' where z = "January 2004"'
) ^
%] |
|
Looks like you've got an extra single quote crept in there.
All of these should work:
# regular quotes
DBI.query('SELECT x FROM y WHERE z="foo"')
DBI.query("SELECT x FROM y WHERE z='foo'")
# escaped quotes
DBI.query("SELECT x FROM y WHERE z=\"foo\"")
DBI.query('SELECT x FROM y WHERE z=\'foo\'')
# interpolate variable
n = 'foo';
DBI.query("SELECT x FROM y WHERE z='$n'")
DBI.query("SELECT x FROM y WHERE z=\"$n\"")
# placeholders
DBI.query('SELECT x FROM y WHERE z=?', 'foo')
DBI.query('SELECT x FROM y WHERE z=?', n)
A
_______________________________________________
templates mailing list
[EMAIL PROTECTED]
http://lists.template-toolkit.org/mailman/listinfo/templates
