[Zope] multiple INSERT in one sql method

Daniel M. Drucker dmd@3e.org
Sat, 5 Jun 1999 11:45:16 -0400 (EDT)


> Yes, I'm using Gadfly and have:

I'm using MySQL. While <!--#var sql_delimiter--> works fine, a
semicolon doesn't... ineresting.



> INSERT INTO table VALUES ( 'a', 'b', 'c', ... );
> INSERT INTO table VALUES ( 'd', 'e', 'f', ... );
> INSERT INTO table VALUES ( 'p', 'q', 'r', ... )
> * Note the semicolon after all INSERTs but the last.