I am getting this error, and I don't know where it is coming from or where 

to look to trouble shoot it.  Could someone please help me.  



<% If rsL1Stat("week3test1") = "Not Started" or isnull(rsL1Stat

("week3test1")) or rsL1Stat("week3test1") = "failed" then %>

	<tr>

	<td><a 

href="http://online.scs.wsu.edu/level_1/week/week3_1.asp">Week 3 

Test1</a></td>

	</tr>

<%End If%>



It gives me this error message:



ADODB.Field error '800a0bcd' 

Either BOF or EOF is True, or the current record has been deleted; the 

operation requested by the application requires a current record. 



/empdev/first_level_current_assignments.asp, line 29 



Thank you in advance...



Derek

This usually occurs when you try to access fields in a recordset, but the

cursor is not pointing at a valid record (eg because there are /no/ records

in the recordset).



Are you testing for objRS.EOF before you start to write anything out?



objRS.Open ...

If objRS.EOF then

    Response.Write("No Matching Records")

Else

    Do While Not objRS.EOF

        ...do stuff here

        objRS.movenext

    Loop

End If



?



Cheers

Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: <dap_1911@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Tuesday, July 24, 2001 2:23 AM

Subject: [asp_databases] ADODB.Field error '800a0bcd'





: I am getting this error, and I don't know where it is coming from or where

: to look to trouble shoot it.  Could someone please help me.

:

: <% If rsL1Stat("week3test1") = "Not Started" or isnull(rsL1Stat

: ("week3test1")) or rsL1Stat("week3test1") = "failed" then %>

: <tr>

: <td><a

: href="http://online.scs.wsu.edu/level_1/week/week3_1.asp">Week 3

: Test1</a></td>

: </tr>

: <%End If%>

:

: It gives me this error message:

:

: ADODB.Field error '800a0bcd'

: Either BOF or EOF is True, or the current record has been deleted; the

: operation requested by the application requires a current record.

:

: /empdev/first_level_current_assignments.asp, line 29

:

: Thank you in advance...