[Zope] ZSQL Methods and multiple SQL statements

[kapil thangavelu]

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