[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