You need to insert the following line between two SQL statements. <dtml-var sql_delimiter> Remember you can't use it with more than one SELECT. sql_delimiter is usefull only to separate more than one INSERT, UPDATE, DELETE. José Andy McKay wrote:
Ive looked through the docs and Im sure I saw once (but cant see it now), some sort of delimiter between SQL statements allowing me to put multiple SQL statements in one SQLMethod. Was I imagining that? -- Andy McKay.
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )