ASP(match values of two table )
-
i m displaying projectdescription whose id is retreived frm previous filename.i have two tables in my database. i m checking if both the id is matched then it should show me the description otherwise not and should display some message. if id is matched then it works fine. but if id is not matched of both the table with one another then it gives error '80020009' here is my code <% opendatabase conn id=request("id") session("id")=id sql="select * from projectdescription where id="& id set obj=server.createobject("adodb.recordset") obj.open sql,conn,1,1 sql3="select * from schemedescription where projectid="& id set obj3=server.CreateObject("adodb.recordset") obj3.open sql3,conn,1,1 response.Write("id is "& obj("id")) if obj3.eof=true then response.Write("record not found") response.Write("[View Project](project.asp?id=" & obj("id") & ") ") elseif obj3.eof=false then response.Write("record found") end if if obj.eof=true then response.Write("rec not found") elseif obj.eof=false then response.Write("rec found") end if if obj("id")=obj3("projectid") then response.Write("[View Project](project.asp?id=" & obj("id") & ") ") response.Write("[View Scheme](scheme.asp?id=" & obj("id") & ") ") response.Write("[View Team](team.asp?id=" & obj("id") & ")") ' else ' response.Write("id is not match") end if %>