Hi,
I'm having trouble getting this ASP code to work. I want to retrieve the record just added, and found the scope_identity() syntax, but I get the following error:
Microsoft JET Database Engine error '80040e14'
Characters found after end of SQL statement.
Original code:
Query = "INSERT INTO tbl_requests([id], [from], [days], [requested], [manager]) VALUES ('" & Session("id") & "','" & request("date_from") & "','" & request("date_days") & "','" & date() & "','" & request("manager") & "'); SELECT SCOPE_IDENTITY();"
kbRS.Open Query, strConn, adOpenStatic, adLockOptimistic
Thanks in advance for anyone's help!
T