Forums
This topic is locked
NEW PROBLEM - EOF BOF problem
Posted 27 Mar 2003 14:15:15
1
has voted
27 Mar 2003 14:15:15 Aodhan Flynn posted:
Getting erro telling me "ADODB.Field (0x80020009)Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/users/admin.asp"
<form name ="confirm_d_e" method="post" action="confirm_d_e.asp">
<input type="hidden" name="company_id" value="">
<input type="hidden" name="company_name" value="">
<%
Set Con = Server.CreateObject("ADODB.Connection"
Con.Open "dbireland"
set RSnow = Server.CreateObject("ADODB.recordset"
RSnow.Open "SELECT * FROM companys ", con
%>
<table border="1" width="75%">
<tr>
<td colspan="6"><div align="center"><strong>To Edit or Delete any of the
companys just click on the Company Name</strong></div></td>
</tr>
<tr>
<td width="100"><div align="center"><strong>Company ID</strong></div></td>
<td width="100"><div align="center"><strong>Company Name</strong></div></td>
<td width="100"><div align="center"><strong>Email Address</strong></div></td>
<td width="100"><div align="center"><strong>Address One</strong></div></td>
<td width="100"><div align="center"><strong>Address Two</strong></div></td>
<td width="100"><div align="center"><strong>County</strong></div></td>
</tr>
<%
Do While not RSnow.EOF
%>
<tr>
<td><div align="center"><%=RSnow("company_id"%></div></td>
<td> <div align="center"><a href="javascript:window.document.confirm_d_e.company_id.value ='<%=RSnow("company_id"%>';window.document.confirm_d_e.submit();"><%=RSnow("company_name"%></a> </div></td>
<td><div align="center"><%=RSnow("email"%></div></td>
<td><div align="center"><%=RSnow("address_one"%></div></td>
<td><div align="center"><%=RSnow("address_two"%></div></td>
<td><div align="center"><%=RSnow("county"%></div></td>
</tr>
<%
Rsnow.Movenext
Loop
%>
</table>
</form>
Replies
Replied 29 Mar 2003 20:04:36
29 Mar 2003 20:04:36 johan tessens replied:
It means you are calling a empty recordset. Try without the EOF if you can pull data from your db.