
April 28th, 2004, 11:26 AM
|
|
Registered User
|
|
Join Date: Apr 2004
Posts: 3
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Multiple-step OLE DB operation generated errors
I am getting the follwing error on my asp page runnning from a MS SQL DB:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done
-Line 48
The code this is referring to is:
Code:
Set conn = Server.CreateObject("ADODB.Connection")
conn.open Application("MyDBConn")
sql = "select * from Loan_Note_Read_Dates where HRId=" & session("id") & " and LoanId=" & request("LoanId") & ""
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
if rs.eof then
rs.addnew
rs("HRId") = session("id")
rs("LoanId") = request("LoanId")
end if
rs("Last_Read_Date") = now()
rs.update
set rs=nothing
Any help or thought would be appreciated??
|