EOF Problem

Results 1 to 2 of 2

Thread: EOF Problem

  1. #1
    kerim ozbakirci Guest

    Default EOF Problem

    Hi,<BR> <BR> I am bringing results from database and displaying 5 records per page. When I say <BR> <BR> &#060;% if rstemp.eof then <BR> <BR> response.write "No Matches"<BR> <BR> else<BR> <BR>Do Until rstemp.EOF<BR>%&#062;<BR> &#060;table&#062;&#060;tr&#062;&#060;td&#062;..... <BR>....<BR> <BR>rstemp.movenext<BR>Loop<BR>...etc..<BR> <BR>After I write this control and execute on the browser, it works fine when data is available in DB. But when there is no data related to that criteria it gives me this error<BR> <BR> Either EOF or BOF is true or current record has been deleted... etc...<BR><BR>Please help me out to solve it<BR><BR>Thanks

  2. #2
    peterjl@austec.net.au Guest

    Default RE: EOF Problem

    It seem like you are coming up with an empty recordset<BR><BR>if rs.EOF and rs.BOF then<BR><BR><BR>If this test gives true then you have an empty recordset.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts