Andreas Jung schrieb:



--On 9. März 2007 14:42:57 +0530 Remil Mathew <[EMAIL PROTECTED]> 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.

Well, it can. See RETURNING clause:
http://www.postgresql.org/docs/8.2/static/sql-insert.html

but I doubt mysql supports this ... checking ... no, it doesnt.

Regards
Tino
_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to