On 11.06.09 14:36, Merav Ben-David wrote:
I am working with zope & mysql.
I have a table with SERIAL column type, I create “z-sql method” for insert operation, how can I get the value for the auto increment column?
I know that in mysql I can call last_insert_id(), how do I call it, should I create another “z sql method” and if I do, how can I be sure the the value return is for my insert command and not for another. Is there a way to call 2 query from the same “z sql method”?
I am really lost on this, any help will be wellcom.
Thank in advanced.
You should be able to write two ZSQL methods and wrap them into a PythonScript. So you call the PythonScript instead of the ZSQL method(s) directly. In addition there is a sql-delimiter tag in DTML afaik - possibly undocumented. I would go for the PythonScript + 2 ZSQL methods approach. -aj