ASP CODE and ms Access catastrophe
I have problem with this code i got error as ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.
/pinner/actionpinn.asp, line 0
code is as follows please help how to resolve this problem i have tried a
lot search in google check my query db everything i have not found any
error
`<html>
<body>
<div id ="pin">
<%
city= Request.Form("username")
area = Request.Form("password")
Dim Conn,rs,strSQL
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open"Provider= Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("/pinner/db/database1.mdb")
'Conn.Open"DRIVER=Microsoft Access Driver(*.mdb);DBQ=" &
Server.MapPath("/pinner/db/Database1.mdb")
'strSQL = "SELECT pincodes.officename FROM pincodes where pincode = '"
& city & "';"
Set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "Select pincode from pincodes WHERE regionname = '" & city
& "' AND officename = '" & area &"';"
rs.Open strSQL,Conn
Response.Write ("<br>")
Response.Write (rs("pincode"))
Response.Write ("<br>")
rs.close
Set rs = Nothing
Set Conn = Nothing
%>
</div>
</body>
</html>`
`
No comments:
Post a Comment