"Greg Rodenroth" <g-rodenroth_at_ti.com> wrote in message
news:c0gl4k$t69$1_at_home.itg.ti.com...
> But I do retrieve them. The records themselves display on my ASP page
even
> with a server side cursor. The only problem is that the recordcount
> property is always -1. If I change the cursor to client side, then the
> recordcount property reads correctly.
>
>
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
> news:CcNWb.14654$_44.18612_at_attbi_s52...
> >
> > "Greg Rodenroth" <g-rodenroth_at_ti.com> wrote in message
> > news:c0g5as$r4k$1_at_home.itg.ti.com...
> > > All,
> > >
> > > I am trying to get a valid recordcount using MSDAORA as a provider.
All
> > > cursor types (forward, static, dynamic, keyset) return a -1 when using
a
> > > server side cursor. When I use a client side cursor, the recordcount
is
> > > correct, however, some of my recordsets are sizeable, and the client
> side
> > > transfer takes up noticeable processing time.
> > >
> > > Any thoughts?
> > >
> > >
> > Simple, it can't know how many records there are until they are
retrieved.
> > If you actually retrieve them then the count is known.
> > Jim
> >
> >
>
>
Do you check the rowcount AFTER you retrieve them or before? And if after
then you could just count them yourself.(If rowcount is -1 after you
retrieve the rows then the driver is broken.)
Jim
Received on Thu Feb 12 2004 - 21:39:46 CST
