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

Vid Bijelic zoops4@yahoo.com
Tue, 18 Dec 2001 09:30:46 -0800 (PST)


Hi,

For MS SQL you have to use  GO  between statements,
might be same for MS Access

Vid

--- Garry Steedman <gs@styrax.com> wrote:
> 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."            
> +-------------------------------------------+
> 
> _______________________________________________
> 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 )


__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com