Stopping EOF(End Of File) from happening?

Question posted by: Pauley (Newbie) on March 28th, 2008 02:51 PM

Hello again,

I have an asp page that displays a list of records according to what im pulling in from my select statement. As long as there is a record in the database the page works fine but if all records in the database are deleted then the page crashes.

I've used the same code in other pages and have no problem with it but for some reason this page either hits EOF or BOF and the page just doesn't load. I've tried a bunch of different "If" statements and different combinations of the EOF or BOF statements to try and stop it from hitting end of file but it still does.

Is there an easy way to stop this from happening using my code below?

Code: ( text )

set rs = server.createobject("adodb.recordset")
dim location
location = Session("location")
strSQL = "SELECT * " _
& "FROM db_accessadmin.callbacks " _
& "WHERE location ='"& location &"' AND "_
& "status ='Open' OR " _
& "status ='WIP' " _
& "ORDER BY ID desc;"
rs.Open strSQL, oConn, adOpenStatic
Dim intcount1
intcount1 = 0
If Not rs.EOF Then
rs.MoveFirst
Do while Not rs.EOF
StartTime = rs("date")
diff1 = (DateDiff("h",StartTime,EndTime))
intcount1 = intcount1 + 1
dim count1
count1 = intcount1
response.write "<tr><td>" & rs("admin") & "</td>"
response.write "<td>" & rs("ticket") & "</td>"
response.write "<td>" & rs("helpdesk") & "</td>"
response.write "<td>" & rs("division") & "</td>"
response.write "<td><center>" & diff1 & "</td></center>"
response.write "<td><a href='ADMINUpdateCallback.asp?FID=" & rs("ID") & "&queue=" & diff1 & "'>" & rs("status") & "</a></td></tr>"
rs.moveNext
loop
End If
response.write "All Other Callbacks = " & count1 & ""
rs.close
set rs=nothing
oConn.close
set oConn=nothing

Any assistance would be greatly appreciated!

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).