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 - [EMAIL PROTECTED]
> 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 )
>
_______________________________________________
Zope maillist - [EMAIL PROTECTED]
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 )