"Daniel M. Drucker" wrote:
Is it possible to do more than one INSERT in a single SQL method?
Yup. You need to use use sql_delimiter variable: insert into data values(1) <!--#var sql_delimiter--> insert into data values(2) Basically, you can have any number of sql statements separated by the delimiter. You cannot use more than one select statement. (Some DAs let you have multiple selects if the result tables all have the same schema.) Jim -- Jim Fulton mailto:jim@digicool.com Python Powered! Technical Director (888) 344-4332 http://www.python.org Digital Creations http://www.digicool.com http://www.zope.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.