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

From: Gabriel Mejía (gabrielme_at_elcolombiano.com.co)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 16:25:02 -0500

 but why it does happen some times and some doesn´t??? does it have sense?

"Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom> escribió en el mensaje
news:OrjXokFGFHA.208@TK2MSFTNGP12.phx.gbl...
> > 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
>
>
> >
> >
>
>

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). ... number of records (the one that is affected by SET NOCOUNT ON). ... Examine NextRecordSet and programme for this. ... If BOF and EOF are both TRUE then the Recordset is empty. ...
    (microsoft.public.data.ado)
  • Re: Operation must use an updateable query
    ... think it has something to do with either having to restart IIS on an NT4 box ... "Stephen Howe" wrote: ... > been opened with the wrong LockMode and I don't see a RecordSet above. ... > Is it an SQL command with INSERT, ...
    (microsoft.public.data.ado)