Re: [Zope] MySQL LAST_INSERT_ID...

OK to follow up, if you use call mysql using the form select CONCAT(LAST_INSERT_ID()) as new_id you get back the correct value in 'last_id'

Umm that should read select CONCAT(LAST_INSERT_ID()) as last_id -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tom Jenkins DevIS (http://www.devis.com) Linux & Samba 2.0 : The best Windows file server http://www.zdnet.com/sr/stories/issue/0,4537,2196106,00.html "Do not be overcome by evil, but overcome evil with good." Romans 12:21