[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