Need @@identity in an ASP
Posted on 1998-10-07
I execute a query that reads:
INSERT INTO table (field1, field2) VALUES (2,2)
SELECT @@identity as ident
If I do that in the Interdev data environment, it returns a table with one column labeled "ident" and the value of the identity field just assigned. When I do the same thing in my ASP then try to access the recordset("ident"), I get "invalid procedure on closed object". Any ideas?