"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.