[Zope] How can run multiple query in an Z sql method

[Andreas Jung]

--On 9. März 2007 14:42:57 +0530 Remil Mathew <remil.dm at gmail.com> wrote:

> Hi,
> How can run  multiple query in an Z sql method..

Sure. SQL Statement just have to separated by <dtml-sql-delimiter>.

I am using Mysql..
> Also is there any method to return a value from insert query?

An insert statement does not return a value! If you are working
with sequences for generating the primary  key you might perform
a select on the current value of the related sequence.

-aj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20070309/d73a31db/attachment.bin