#7 mysql_insert_id() usage

open
Mark Hessling
None
5
2003-02-02
2002-12-01
Anonymous
No

How can I get the result form the

mysql_insert_id()

function with Rexxsql?

Last_insert_id won't do me for my current application,
I need to store this value for future use.

Thanks
Miles

Discussion

  • Mark Hessling
    Mark Hessling
    2003-02-02

    • assigned_to: nobody --> rexx
     
  • Mark Hessling
    Mark Hessling
    2003-02-02

    Logged In: YES
    user_id=86185

    Why wouldn't:
    /**/
    Call sqlcommand 'q1', 'select last_insert_id() as lid'
    Say q1.lid.1
    do what you want ? q1.lid.1 has the last value of the
    auto_increment column.