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

[Vid Bijelic]

Hi,

Just place ; at the end of sql statement.

delete from table1;

insert into table1
values(1,'Hello');

insert into table1
values((select MAX(teable1_primary_key) from
table1)+1,'Hello Again');


--- Harlow Pinson <hpinson@indepthl.com> wrote:
> Is is possible to insert multiple SQL statements
> into a single ZSQL 
> method?  Can anyone provide a simple example for
> doing this?
> 
> i.e.; in a single ZSQL method:
> 
> INSERT INTO tbl1 VALUES (field1);
> 
> INSERT INTO tbl2 VALUES (field1);
> 
> 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 )


__________________________________________________
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