adodb, sql server, and last insert id

[jdonnell]

I'm not very familiar with sql server or adodb. I'm writing a python
script that uses adodb as described at http://www.ecp.cc/pyado.html,
but I can't figure out how to get the id of my last insert.

 

[Steve Holden]

I'm not very familiar with sql server or adodb. I'm writing a python
script that uses adodb as described at http://www.ecp.cc/pyado.html,
but I can't figure out how to get the id of my last insert.

The classic method, IIRC, is as follows for SQL Server and recent
versions of Jet:

curs.execute("SELECT @@IDENTITY")
id = curs.fetchall()[0][0]

For MySQL it would be

curs.execute("SELECT LAST_INSERT_ID()")
id = curs.fetchall()[0][0]

regards
Steve

 

[jdonnell]

Thanks for the reply. I found that before I posted, but that doesn't
look thread safe and I haven't found anything that says it is or isn't.