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

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