[Zope] ZMySQLDA and ZSQLMethods

[Andrew Altepeter]

I have a zsql method that inserts data into a table with an
auto_increment column, and then calls select last_insert_id():
----------------------
INSERT INTO cc_transactions(acct,who,total,creationtime)
  VALUES(<dtml-sqlvar account type="string">,
         <dtml-sqlvar who type="string">,
         <dtml-sqlvar total type="float">,
         NOW())
<dtml-var sql_delimiter>
SELECT LAST_INSERT_ID() as id from cc_transactions
----------------------

One would expect to get just one integer (well, id:integer) back from
calling this method.  However, I get a list of id:integers with every
id=actual last_insert_id, and a length equal to the number of rows in
the table.

I haven't been able to recreate this behavior in a mysql shell client.

Any ideas about what's going on?

my mysql version is: 3.23.58

Thanks,
Andy