6 Jan
2004
6 Jan
'04
8:25 p.m.
On Tue, 6 Jan 2004 13:55:07 -0500 (EST) Asad Habib <ahabib@engin.umich.edu> wrote:
Hello. Does anyone know if you can have multiple queries within a single Z SQL method? Thanks.
- Asad
Yes, so long as they do not return records. just put <dtml-var sql_delimiter> lines between them. i.e.: UPDATE foo SET BAR=NULL <dtml-var sql_delimiter> UPDATE baz SET splat=NULL This allows you to perform multiple inserts/updates/deletes in a single database transaction for instance. hth, -Casey