If, Not???

[S James]

I am pulling info form a DB and for some reason if I try and pull a info
from a related table that does not have any info equaled to the query, I get
the error:

ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record.
/secure/admin/commresult.asp, line 61

but if there is info in the table. The page comes up fine.



Here is the lines of code, how can I setup so if there is no records
to just do nothing instead of giving an error??

<%
While ((Repeat1__numRows <> 0) AND (NOT rscommresult.EOF))
%>
<tr>
<td><%=(rscommresult.Fields.Item("CommName").Value )%></td>
<td>&nbsp;</td>
</tr>
<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rscommresult.MoveNext()
Wend
%>

[Ken Ford - *TMM* & PVII]

Use the Show If server behaviors.

--
Ken Ford
PVII Support Team
[url]http://www.projectseven.com[/url]
Team Macromedia Volunteer - Dreamweaver
Certified Dreamweaver MX 2004 Developer


"S James" <Sjames@tampabay.rr.com> wrote in message news:d1lmks$pf0$1@forums.macromedia.com...

>I am pulling info form a DB and for some reason if I try and pull a info from a related table that does not have any info equaled
>to the query, I get the error:
>
> ADODB.Field error '800a0bcd'
> Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
> /secure/admin/commresult.asp, line 61
>
> but if there is info in the table. The page comes up fine.
>
>
>
> Here is the lines of code, how can I setup so if there is no records to just do nothing instead of giving an error??
>
> <%
> While ((Repeat1__numRows <> 0) AND (NOT rscommresult.EOF))
> %>
> <tr>
> <td><%=(rscommresult.Fields.Item("CommName").Value )%></td>
> <td>&nbsp;</td>
> </tr>
> <%
> Repeat1__index=Repeat1__index+1
> Repeat1__numRows=Repeat1__numRows-1
> rscommresult.MoveNext()
> Wend
> %>
>
>
>
>
>