[Zope] Getting Auto Increment value

[Andreas Jung]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lists.vcf
Type: text/x-vcard
Size: 330 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20090611/290157ef/attachment.vcf