[Zope] insert_id with MySQL an Z SQL Method

Hi, I have a Z SQL Method with an insert expression. To the inserted row will be assigned an auto_increment id. How can I get the last inserted id? I tryed the following both commands in one Z SQL method. Unfortunatly this produces an error. insert into categories (parent_id,logo,active) values ( <dtml-sqlvar parent_id type="int">, <dtml-sqlvar logo type="string">, <dtml-sqlvar active type="int">, ); SELECT currval('table_id_seq'); Thanks for your helps Greets, Ferhat __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com