On Wed, Jan 17, 2001 at 04:36:29PM -0800, 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.
No indeed, any number of SQL statments may be in a ZSQL Method, although at most one may be a SELECT. If you know your databases convention, you can use the normal separator, i.e. PostgreSQL supports ';' as the separator. Just do it. This may cause portability problems. <dtml-var sql_delimiter> is supposed to be portable.
_______________________________________________ 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 )