[Zope] sql_delimiter broken?
Tino Wildenhain
tino at wildenhain.de
Tue Jan 25 00:52:10 EST 2005
Am Montag, den 24.01.2005, 15:04 -0700 schrieb hpinson at indepthl.com:
> The ability to pass multiple sql calls in one ZSQL method using
> sql_delimiter seems to be broken in 2.7.4.
>
> This no longer works in a single ZSQL method:
>
> INSERT INTO ...;
> <dtml-var sql_delimiter>
>
> INSERT INTO ...;
> <dtml-var sql_delimiter>
>
> Crashes the sql on encountering the sql_delimiter.
>
> Does anyone know of any workaround outside of using separate ZSQL
> methods for each statement? I know... convert it to Python.
No, just dont use 2 delimiter.
You have used ; _and_ sql_delimiter which would render to ;
too. I'm also not certain if the syntax was correct.
It should be something like sql-delimiter
Which renders ; too :-)
More information about the Zope
mailing list