[Zope] Getting Auto Increment value

[Thomas Bennett]

I am suspecting that serial in MySQL works like serial in PostgreSQL in which 
a sequence is automatically created.  If so, you should be able to query the 
last_value field in the sequence without having to call the function.  The field 
name might be different in MySQL, I don't know.  This will give you the last 
value inserted and if you need the next just add 1.

  Also, if it is an auto increment column and again if it is like PostgreSQL 
then all you have to do is use the word 'default' without quotes and it "auto 
increments" the value for the new insert.  See if there is a default for your 
serial field.

Thomas





On Thursday 11 June 2009 08:36:21 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.

-- 
 Normally I'm against big things, 
 I think the world is going to be saved by millions of small things. 
Too many things can go wrong when they get big.
- Pete Seeger  at his 90th birthday party Sunday May 3, 2009

==========================================
Thomas McMillan Grant Bennett           Appalachian State University
Operations & Systems Analyst            P O Box 32026
University Library                                Boone, North Carolina 28608
(828) 262 6587

Library Systems Help Desk: https://www.library.appstate.edu/help/
==========================================