tamakuwalapranav Posted May 29, 2006 Share Posted May 29, 2006 Hi all, I have connect my ASP file with MS Access database and I have hips of records in my database.Actual senario:when I start my application, it will start with login page. Once I enter my username and password , it will check in database and it finds and record under that username and password, it will display that users personal information and few others information according to HTML designing page. But whats happening is that I can enter my username and password but after that page comes up with this erros msg:Error Type:ADODB.Field (0x80020009)Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.Now I want to know that how can I remove this error msg and where do put loop or any thing that could help me out to remove this error.My Coding: <%if session("txtusername")="" thenResponse.Redirect("default.asp")end if%><%if session("txtusername")="" thenResponse.Redirect("default.asp")end if%><%loginname= session("txtusername")username=request.form("username")password=session("txtpassword") Set con = Server.CreateObject("ADODB.Connection")con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("Academic.mdb")Set rs1=server.CreateObject("ADODB.Recordset")sql1="select * from student where username='"&txtusername&"' and password='"&txtpassword&"'"rs1.open sql1,con, adCmdTable%><html><head><title>Student Enrolment Form</title><h4> <font color="#FFFFFF">Personal Information </font></h4><tr><td align="right"><font size="2"><b>Family Name (*)</b></font><td colspan="2"> <div align="left><font size="2"><input name="famname" onBlur= isAlpha(this) size="35" maxlength="20" value="<% = rs1("lastName") %>" ></font></div></td></tr><br><input type="submit" name="Submit" value="Update"> <input type="reset" value="Cancel"><br></br><centre> <b> <font color="05379A"> Note: (*) mendetory fields </font></b> </form></body></html><%rs1.CloseSet rs1 = NothingSet con = Nothing%>In above code, lastName is my database field.Cheers,PRANAV Link to comment Share on other sites More sharing options...
justsomeguy Posted May 31, 2006 Share Posted May 31, 2006 I'm assuming the error happens here:<input name="famname" onBlur= isAlpha(this) size="35" maxlength="20" value="<% = rs1("lastName") %>" >That error happens when the recordset does not contain any information. You can avoid it with a check for BOF or EOF <%if not rs1.EOF and not rs1.BOF then lname = rs1("lastName")else lname = ""end if%><input name="famname" onBlur= isAlpha(this) size="35" maxlength="20" value="<% = lname %>" > Someone else might need to check my syntax with VB, it might not be right. Link to comment Share on other sites More sharing options...
jojay Posted May 31, 2006 Share Posted May 31, 2006 In above code, lastName is my database field.Cheers,PRANAV<{POST_SNAPBACK}> What does the above quote mean? Do you have only lastname as database field? where does the username and password come from? In your error message, the error will point out to your filename and line number, where does it points to? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now