seemingly random database errors

[Manic]

Basicaly i put in a location through a link and want the output but this only works for half of my calls.

I have 10 diferent location with and without data. it works for some with and without data and not others.

The error I get is

Error Type:
(0x80020009)
Exception occurred. 
/asset/show_location.asp, line 49

Line 49 is the second call of [highlight]rsPC("Patched")[/highlight]

<%


If rsPC.BOF and rsPC.EOF Then
		Response.Write "</table>"
		Response.Write "<h2 align='center'>No equipment found for "& R &" </h2>"
Else

rsPC.MoveFirst
Do Until rsPC.EOF
		Response.Write "<tr><td colspan='5' height='1' class='Nav_Admin_Line'></td></tr>"
		Response.Write "<tr><td valign='top'>" & rsPC("Patched") & "</td>"
		Response.Write "<td valign='top'>" & rsPC("PC_Name") & "</td>"
		Response.Write "<td><a href='show_user.asp?ID="& rsPC("ID") & "'>" & rsPC("User") & "</a></td>"
		Response.Write "<td valign='top'>" & rsPC("Dept") & "</td>" 
		Response.Write "<td valign='top'>" & rsPC("IP") & "</td></tr>"
   rsPC.MoveNext
   		Response.Write "<tr><td colspan='5' height='1' class='Nav_Admin_Line'></td></tr>"
		[highlight]Response.Write "<tr class='show_odd'><td valign='top'>" & rsPC("Patched") & "</td>"[/highlight]
		Response.Write "<td valign='top'>" & rsPC("PC_Name") & "</td>"
		Response.Write "<td><a href='show_user.asp?ID="& rsPC("ID") & "'>" & rsPC("User") & "</a></td>"
		Response.Write "<td valign='top'>" & rsPC("Dept") & "</td>" 
		Response.Write "<td valign='top'>" & rsPC("IP") & "</td></tr>"
   rsPC.MoveNext
Loop 

End If 
%>

Manic
-----------------------------
I've broken it again !!
-----------------------------

 

[ChrisHirst]

you have 2 rsPC.MoveNext ops in one loop.

this will cause the last iteration to go beyond the end of the recordset.

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Manic]

Thanks didn't think about that.

now need to work on if statement.

Manic
-----------------------------
I've broken it again !!
-----------------------------

 

[DreXor]

just use "if not rspc.eof then " afteryour move next statement, you will probably need to add an Else to it to response out an empty set of <TD>'s so that you dont ruin the page format when you hit the end of the recordset

you will only need this on the bottom half and make sure the second rspc.movenext is inside the first portion of the if statement, otherwise you'll get an error on the movenext line



DreX
aKa - Robert