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

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