You can get a ZSQLMethod that's used for inserting to return the last inserted ID by doing the following: INSERT ...whatever... <dtml-var sql_delimiter> SELECT LAST_INSERT_ID() AS newid You get the results as you would with any ZSQLMethod: <dtml-in my_zsql_method> Inserted ID: <dtml-var newid> </dtml-in> _______________________ Ron Bickers Logic Etc, Inc. rbickers@logicetc.com
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Andy Sent: Wednesday, May 17, 2000 7:45 PM To: zope@zope.org Subject: [Zope] ZSQL-Methods: last inserted id
I wonder how I can find out about the last inserted id of a row in my mysql-database, which I inserted through a ZSQL-Method...
I tried mysql's built-in function LAST_INSERT_ID(), but that did not solve my problem...
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )