Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible to get valid recordcount with MSDAORA?
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
>
>
Received on Thu Feb 12 2004 - 13:45:22 CST