Tom: [Reading from my support script..] This is where I say, "Hmm, I'm no expert on MySQL...." ;^) Anyone else have any ideas? This, um, worked on Sybase!? --Rob 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()
Rob Page replied:
Try:
select LAST_INSERT_ID() as fred
then grab <!--#var fred-->
If this works then I know what the problem is! :^)
If you use the database's command line tool and run this SQL statement I bet it returns a single value (i.e., it doesn't return a table). The DA wants to munge and chew on rows in tables. If think that if you use the select LAST_INSERT_ID() as fred you'll get a one-row, one-column table -- this is what Zope wants.
Then Tom wrote back:
Hi Rob, Made the change and tested but still got the exception. I ran it at the command line (for mysql) and it returns a "table" with one row and field