Hi i get the following error while using this page... The records are there in the database while trying to update..
Please help me in this...
Thirulok...
Error Type: ADODB.Field (0x80020009) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record
<%
if Session("contractorlogin")="" then
response.Redirect "contractorlogin.asp"
else
contractorcode=Session("contractorcode")
set objrs=server.CreateObject("adodb.recordset")
strsql="select * from contractortable where contractorcode ='" & contractorcode & "'"
objrs.open strsql,objconn,3,3
%>
<p align="center"><font size="3" face="Verdana, Arial, Helvetica, sans-serif"><b>Change Your Password</b></font>
<font size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
Note: Fields Marked * are Mandatory!</font>
</p>
<form name="form1" method="post" action="contractorpasschange1.asp" onSubmit="return validate()">
<table align="center">
<tr><td></td><td><input name="contractorcode" type="hidden" value="<%=objrs("contractorcode")%>"></td></tr>
<tr><td></td><td><input name="password" type="hidden" value="<%=objrs("password")%>"></td></tr>
<tr><td>*Current Password</td><td><input name="currentpassword" type="password"></td></tr>
<tr><td>*New Password</td><td><input name="newpassword" type="password"></td></tr>
<tr><td>*Re-Type Password</td><td><input name="repassword" type="password"></td></tr>
<tr><td height="40"></td><td><input name="submit" type="submit" value="Change Password"></td></tr>
</table>
</form>
<%
end if
%>
</td>
</tr>
</table>
<p align="center"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">
</font></p>
</body>
</html>
