[thelist] ASP: @@Identity
Tab Alleman
talleman at autobex.com
Fri Nov 10 15:31:44 CST 2000
well, that section of the real code looks like this:
sqlSku = "SELECT @@Identity"
Set rsSku = usConn.Execute(sqlSku)
ThisSku = rsSku.Fields.Item(0).value
rsSku.Close
Set rsSku = Nothing
Any other sections? I didn't wanna post a few hundred lines of my sloppy
code. Nobody would want to help me for sure.
-----Original Message-----
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
More information about the thelist
mailing list