[Zope-DB] Compound SQL Statements

[Roy S. Rapoport]

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:
---
INSERT INTO person
(Login, Password, FirstName, LastName, Email, Organization, Title, Street1,
Street2, City, State, Postal, Country)
VALUES(
	'roy2',
	'as',
	'asdf',
	'asd',
	'sd',
	'da',
	'a',
	'd',
	'd',
	'j',
	'j',
	'j',
	'j'
);

SELECT LAST_INSERT_ID()
---
 
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?

-roy