[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