Harlow, IIRC it depends on the ODBC/RDBMS implementations: check your docs for these and you should be able to work out if they support multiple sql statements... g On 18 Dec 2001, at 9:43, Harlow Pinson wrote: From: "Harlow Pinson" <hpinson@indepthl.com> To: Vid Bijelic <zoops4@yahoo.com> Subject: Re: [Zope] Multiple SQL statements in a single ZSQL method? Send reply to: hpinson@indepthl.com Copies to: zope@zope.org Priority: normal Date sent: Tue, 18 Dec 2001 09:43:56 -0700
Just place ; at the end of sql statement.
When I do that, I get an ODBC error:
Error Type: sql.error Error Value: ('37000', -3517, '[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.')
Here's my very simple SQL statement, in the ZSQL method:
INSERT INTO tblUsers VALUES ( 5 );
INSERT INTO tblParents VALUES ( 5 );
The first statement by itself works fine.
Harlow Pinson Indepth Learning Email: hpinson@indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
+-------------------------------------------+ Garry Steedman mailto:gs@styrax.com Styrax Associates http://www.styrax.com/ "The Good Man has no shape." +-------------------------------------------+