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 )
