[Zope] Simple query using ZMySQLDA => (1064, "You have an error in your SQL syntax near ' LIMIT 1000' at line 2")

[Davis Marques]

Thomas;

You've probably already received a response on this, but you need to use
<dtml-sqlvar VARNAME> instead of <dtml-var VARNAME> in the query.  For
example:

select * from elope_moviereviews where emr_id = <dtml-sqlvar emr_id>

I wasn't clear on what you intended with the <dtml-var sql_delimiter>, so
I've left it out here.

Davis
--
McCall Design Group
550 Kearny Street, Suite 710
San Francisco California USA 94108