Re: really baffled - a might OT about recordset EOF

From: Stephanie Stowe (NoSpam_at_IWishICould.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 08:21:39 -0500

"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
news:#T#4bg1yEHA.3808@TK2MSFTNGP15.phx.gbl...
> Stephanie Stowe wrote:
> >>>
> >>> I logged the contents of the string and the value of rs.eof. When I
> >>> pasted the string into SQL Server, I get a row, as expected. Yet
> >>> rs.eof is TRUE. Have I lost my noodle? I knew that with certain
> >>> cursor types you cannot rely on RecordCount or whatever property
> >>> that is that I have not used in a millenium... But EOF?
> >>>
> >>
> >> Well, it says "Not rs.EOF" - should it return true for empty
> >> recorsets and false for populated recordsets?
> >>
> >
> >
> > The recordset.eof is what I am testing. If I do
> >
> > LogWarn "The value of recordset eof is: " & cstr(rs.eof)
> >
> > where logwarn is a proc which writes a warning to the EventLog I am
> > seeing
> >
> > The value of the recordset eof is: true" in the event log despite the
> > fact that when I paste the exact same query into query analyzer, I
> > get a row.
> >
>
> Have you done a Move in the recordset before testing EOF?

Nope.

> If so, it may need
> to be requeried. I've never seen a populated recordset return a true EOF
> without some sort of navigation in the recordset having taken place.

Me neither. Thus the bafflement.

> If you
> check EOF immediately after opening the recordset, it should be pointed at
> the first record if the recordset contains any recorcords at all, so EOF
> will be false.
>

So I thought also.

> Please post a true repro for this issue if the above does not answer your
> question.
>

The entire function with my crazy event log entries are in my reply to
Aaron. I am at a complete loss on this one. I almost think I am not seeing
what I am seeing, and that there is an error in my troubleshooting
technique. It would not be the first time.

> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>

Relevant Pages