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

Florent Guillaume fg@nuxeo.com
17 Dec 2001 20:27:26 GMT


Actually <dtml-var sql_delimiter> is the preferred method.

Florent


Vid Bijelic  <zoops4@yahoo.com> wrote:
> 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);
-- 
Florent Guillaume, Nuxeo (Paris, France)
+33 1 40 33 79 10  http://nuxeo.com  mailto:fg@nuxeo.com