Please,please help me on error ' 80020009'

Results 1 to 2 of 2

Thread: Please,please help me on error ' 80020009'

  1. #1
    Join Date
    Dec 1969

    Default Please,please help me on error ' 80020009'

    hi all!<BR> actually I&#039m really tired now of this exception problem everytime,everytime.<BR>if someone can help me out.someone from list told me that it is due to instr.Now I&#039m not useing the INSTR<BR>function.I&#039m simply comparing the value.<BR><BR>here&#039s my code:--&#062;<BR>&#060;%<BR> Dim rsRam,rsPin,conn<BR> set conn=server.CreateObject("Adodb.connection")<BR> conn.Open "FILEDSN=ProclaimDevelop.dsn;uName=Skapil;pwd=kapi l"<BR> <BR> sql = "Select ram_id from ramApplicationProcess where ram_id=&#039" & Request.form("ApplicationID") & "&#039" <BR> sql1="select * from Access_key_Table where PIN_NO=&#039" & Request.Form("PIN") & "&#039"<BR> securepage="http://localhost/Protege1/ApplicationForm.asp"<BR> <BR> set rsRam=Server.CreateObject("Adodb.Recordset")<BR> rsRam.Open sql,conn<BR> <BR> set rsPin=server.CreateObject("Adodb.Recordset")<BR> rsPin.Open sql1,conn<BR> <BR> if rsPin("PIN_NO")=Request.Form("PIN") and rsRam("ram_id")=Request.Form("ApplicationID") then &#039Error occured here<BR> Response.Redirect(securepage)<BR> else<BR> Response.Write "Invalid User"<BR> end if <BR> <BR> rsRam.Close <BR> set rsRam=nothing<BR> rsPin.Close <BR> set rsPin=nothing<BR> conn.Close<BR> set conn=nothing <BR>%&#062;<BR><BR>error &#039 80020009&#039 <BR>Exception occurred. <BR>/Protege1/ApplicationInquiryPage.asp, line 53 <BR>please help me out.<BR>Millions of thanx in advance,<BR>Regards,<BR>Vicky.

  2. #2
    Join Date
    Dec 1969

    Default RE: Please,please help me on error ' 80020009&

    Try:<BR><BR>if rsPin.Fields("PIN_NO")=Request.Form("PIN") and rsRam.Fields("ram_id")=Request.Form("ApplicationID ") then <BR><BR>If that doesn&#039t work try:<BR><BR>if rsPin.Fields("PIN_NO").Value=Request.Form("PIN") and rsRam.Fields("ram_id").Value=Request.Form("Applica tionID") then <BR><BR>The thing is that rs("field") is actually a reference to the recordset object, not the value of the field - there&#039s some stuff goes on behind the scenes to hide this fact, but it sneaks up every now and then. I always use rs.Fields("field") instead.<BR><BR>Dunc<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts