[Zope] Multiple SQL statements in a single ZSQL method?

[Garry Steedman]

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