Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-20 : 11:50:43
|
Mark writes "Hi,
I have an error after trying to retrieve the @@identify variable after submitting a web form to a sql backend database.
The script was previously working and hasn't been modified so I think something has happend or has been changed oin the server.
I get this error
after doing an update.
Microsoft OLE DB Provider for ODBC Drivers error '80040e23'
[Microsoft][ODBC SQL Server Driver]Cursor operation conflict
/knowledge/addrecord.asp, line 43
this is line 43 in my code
We're done, so update the record
objRS.Update
'This line of code will get us the indentity value for the row
' we just inserted!!
Set objRSIdentity = objConn.Execute("SELECT @@IDENTITY FROM userdetails")
userid = objRSIdentity(0)
hope you can help
cheers
Mark" |
|
|
|
|
|
@@identity server variable and asp