[Zope] multiple INSERT in one sql method

[Jim Fulton]

"Daniel M. Drucker" wrote:
> 
> > 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.

The use of a semicolon is a featue of some SQL UIs, it is not part of SQL.
SQLMethod use <!--#var sql_delimiter--> instead.

Jim

--
Jim Fulton           mailto:jim@digicool.com
Technical Director   (540) 371-6909              Python Powered!
Digital Creations    http://www.digicool.com     http://www.python.org

Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
address may not be added to any commercial mail list with out my
permission.  Violation of my privacy with advertising or SPAM will
result in a suit for a MINIMUM of $500 damages/incident, $1500 for
repeats.