[Zope] ZSQL Methods and multiple SQL statements

kapil thangavelu kvthan@wm.edu
Fri, 22 Feb 2002 20:38:25 -0800


On Wednesday 13 February 2002 03:00 pm, Jon Dyte wrote:
> Hi
>
> is it the intention that ZSQLMethods could contain more than
> one SQL statement?
>
> eg (ridiculous example I know)
>
> insert into foo values('bar'); delete from foo
>
>


try using the <dtml-var sql_delimiter> syntax between statements. one 
restriction, you can't do multiple select statements. this is covered in the 
documentation. 

hth

kapil