[thelist] ASP: @@Identity
Anthony Baratta
Anthony at Baratta.com
Fri Nov 10 15:20:58 CST 2000
At 12:58 PM 11/10/2000, you wrote:
>Problem: My @@Identity is experiencing a meltdown in the middle of my script
>and I don't know why.
Can we see some real code? That would help me to help you. When I grab
@@Identity I do this:
strQuery = "INSERT INTO TableOne VALUES(Null,"
strQuery = strQuery & blah blah blah
objDB_Connection.Execute(strQuery)
objDB_RecordSet.Open "Select @@Identity"
varIdentity = objDB_RecordSet(0)
objDB_RecordSet.Close
----
Anthony Baratta
President
Keyboard Jockeys
More information about the thelist
mailing list