25 Jan
2005
25 Jan
'05
5:52 a.m.
Am Montag, den 24.01.2005, 15:04 -0700 schrieb hpinson@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 :-)