[Zope] SQL delimiter?

[jpenny@universal-fasteners.com]

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 )
>