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