Hey folks, this is my first questions so bear with me.
On part of my page i'm calling a sub that updates a recordset in a userlist. Here it is:
sub up_user (id, status)
dim who_status
rs.Open "SELECT * FROM ulist WHERE id=" & id, Conn
rs.movefirst
who_status = rs("status"
& " " & status
rs("status"
= who_status
rs.Update
rs.close
Response.Write "Record id " & id & " updated to " & status & "<br>"
end sub
Its being called with:
up_user request.querystring("id"
, request.querystring("status"
where the status is being appended to the current status.
I just transfered the database from access to mysql and its working fine and good until i started getting this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/admin/admin_user.asp, line 74
Line 74 is refering to rs("status"
= who_status
If anyone could lend a hand or idea as to why i'd be very thankfull.
-Nick
On part of my page i'm calling a sub that updates a recordset in a userlist. Here it is:
sub up_user (id, status)
dim who_status
rs.Open "SELECT * FROM ulist WHERE id=" & id, Conn
rs.movefirst
who_status = rs("status"
rs("status"
rs.Update
rs.close
Response.Write "Record id " & id & " updated to " & status & "<br>"
end sub
Its being called with:
up_user request.querystring("id"
where the status is being appended to the current status.
I just transfered the database from access to mysql and its working fine and good until i started getting this error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/admin/admin_user.asp, line 74
Line 74 is refering to rs("status"
If anyone could lend a hand or idea as to why i'd be very thankfull.
-Nick