Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: Users
Getting Auto Increment value
 

Index | Next | Previous | View Flat


Merav.B at puresight

Jun 11, 2009, 5:36 AM


Views: 768
Permalink
Getting Auto Increment value

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.

Subject User Time
Getting Auto Increment value Merav.B at puresight Jun 11, 2009, 5:36 AM
    Re: Getting Auto Increment value lists at zopyx Jun 11, 2009, 5:50 AM
    Re: Getting Auto Increment value robert at redcor Jun 11, 2009, 6:18 AM
    Re: Getting Auto Increment value bennetttm at appstate Jun 11, 2009, 6:25 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.