strange error when closing RS

am confused about an error i keep getting....

ADODB.Recordset error '800a0e78'

Operation is not allowed when the object is closed.

/page.asp, line 13

but the strange thing is... am tryin to "close" the recordset on like 13

b4 i put the "response.redirect" above closing to get it to work.....

but then i thought it wouldnt close the record set

does anyone understand this?

Yeah, you can only get that error if the recordset is definatly open, post your code here if its not too big

sounds like you alreasy closed it, before u redirect do:

set rsObj = Nothing

as well

<!--#include virtual="/include/global.asp"-->
<%
id = Request.QueryString("id")
CID = Request.QueryString("CID")
PID = Request.QueryString("PID")
%>
<!--#include virtual="/include/Conn.asp"-->

<%
  sql = "DELETE * FROM Notes WHERE ID = " & ID
  set rsDelete = conn.Execute(sql)
 
  rsDelete.close
  set rsDelete = nothing
  conn.close
  set conn = nothing

 response.redirect("notes-frame.asp?CID=" & CID & "&PID=" & PID)
%>

 see.... i havent closed it yet... for sum reason it doesnt like to close it

the line in red is line 13

oh... well i kinda learn from this other (kinda crap and "nameless") forum

but i close the RS on other pages and it works fine... hense the reason am confused

it works on sum pages but not others