Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid data

From: Stephen Howe (stephenPOINThoweATtns-globalPOINTcom)
Date: 02/21/05

  • Next message: Stephen Howe: "Re: Is there any (free!) ADO - OLE DB Provider for Lotus Notes?" 
    Date: Mon, 21 Feb 2005 21:06:03 -0000

    > Microsoft give a solution at the article Article ID : 230101
    >
    > but I did it all (I have mdac 2.8 installed and the problem still
    ocurrs).

    Sounds to me like the RecordSet it returns is part of the count of the
    number of records (the one that is affected by SET NOCOUNT ON).

    > any suggestions?

    Examine NextRecordSet and programme for this.
    If BOF and EOF are both TRUE then the Recordset is empty.
    So skip processing of that recordset.
    If you then examine NextRecordSet, you might find it is not Nothing and
    actually contains the records you after. Keep looping until NextRecordSet is
    Nothing

    Stephen Howe

    >
    >

  • Next message: Stephen Howe: "Re: Is there any (free!) ADO - OLE DB Provider for Lotus Notes?"

    Relevant Pages

    • About NextRecordSet
      ... returns multiple resultsets.When i using TADOStoredProc's NextRecordset ... method my current recordset was changed. ... NextRecordSet calls my TADOStoredProc object has point a last ... my stored procedure looks like following; ...
      (borland.public.delphi.database.ado)
    • Re: Please Help before I pull out the last of my hair
      ... Bob Barrows wrote: ... Do I have to do a .NextRecordset just to get the first recordset? ... Microsoft MVP -- ASP/ASP.NET ...
      (microsoft.public.inetserver.asp.db)
    • Re: SET SHOWPLAN_ALL ON in ADO
      ... current recordSet is not NULL, ... answer for the submitted query. ... >> returns a closed recordset. ... > Did you check whether property NextRecordSet is non-NULL? ...
      (microsoft.public.data.ado)
    • Re: sometimes it returns error message: Either BOF or EOF is true in my asp page and it has valid da
      ... > ocurrs). ... > Examine NextRecordSet and programme for this. ... > If BOF and EOF are both TRUE then the Recordset is empty. ... > Stephen Howe ...
      (microsoft.public.data.ado)
    • Re: sp not returning recordset to ASP/VBS page
      ... I have read a lot of your posts. ... my permissions but its not returning a recordset nor generating any ... Set conn = CreateObject ... you need to add "SET NOCOUNT ON" to your procedure. ...
      (microsoft.public.scripting.vbscript)