On Tue, 16 Mar 1999, Tom Jenkins wrote:
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'
now I'm still having problems with getting that value into the REQUEST object. What goes in place of the ??? <!--#call REQUEST.set('last_id', ???)-->
(Pardon me if this has been answered already, there was some problems with me getting messages from zope list) Thanks again...
Well, try something like: <!--#in lastInsert--> <li>The id last inserted is <!--#var new_id--> <!--#/in--> where lastInsert is your SQL method Note this is untested code, so caveat emptor :) Have fun, ------- Jordan B. Baker -- jbb@spyderlab.com weaving the web @ http://www.spyderlab.com