[Zope-DB] Compound SQL Statements

Roy S. Rapoport zope-db at ols.inorganic.org
Tue Jun 29 19:23:20 EDT 2004

I'm using Zope 2.7.0 with ZMySQLDA 2.0.9 and Python-MySQL 1.1.1.

Trying to use this bit of SQL:
(Login, Password, FirstName, LastName, Email, Organization, Title, Street1,
Street2, City, State, Postal, Country)

Within a ZSQL statement nets me:
Error, _mysql_exceptions.ProgrammingError: (1064, "You have an error in
your SQL syntax. Check the manual that corresponds to your MySQL server
version for the right syntax to use near ';\n\nSELECT LAST_INSERT_ID()' at
line 18") 

Even though this seems like perfectly legit SQL code (and it works within a
mysql interpreter).

Thoughts? Is there another recommended way I can get the ID of the last
inserted row?


More information about the Zope-DB mailing list