On Mon, 15 Mar 1999, Tom Jenkins wrote:
To followup my last post, I'm getting an exception when trying to use MySQL's "select LAST_INSERT_ID()" function:
Error, exceptions.KeyError: unhandled
SQL used:
select LAST_INSERT_ID()
Anybody have any ideas?
Try: select LAST_INSERT_ID()+0 to cast it to an int... Also, check your declaration for LAST_INSERT_ID().. if the above doesn't work you'll need to either try the patch for ZMySQLDA that was posted a week or so ago, or do something like: SELECT CONCAT(LAST_INSERT_ID()) to cast it to a string and then use a nifty Python fn. to convert it to an integer number. It seems the MySQL driver has problems with some datatypes. There was a patch posted befure.. I'm curious to know if it'll fix this problem... ------- Jordan B. Baker -- jbb@spyderlab.com weaving the web @ http://www.spyderlab.com