Paging an oRSv array

[Laphan]

Hi All

I used to be able to page through data using the old:

oRSv.CursorLocation = 3
... ... ...
... ... ...

oRSv.PageSize = cMax
TotalPages = oRSv.PageCount
oRSv.AbsolutePage = RSPage
ii = 1

Do while not oRSv.EOF and not ii > cMax
.... .... ...
.... ... ...

etc

But now I've started to use the oRSv.getrows to speed things up and I don't
know the best way (or how for that matter) to page the data now that its in
an array rather than a oRSv....

I want to keep using this array method so if anybody has any paging routines
to cover this, I would really appreciate it if you could post them on to me.

FYR, I am using ASP / ADO / MySQL DB, so I can't use any SProc paging
routines.

Thanks

Laphan

[Aaron [SQL Server MVP]]

[url]http://www.aspfaq.com/2120[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40d88469_3@127.0.0.1...

> Hi All
>
> I used to be able to page through data using the old:
>
> oRSv.CursorLocation = 3
> .. ... ...
> .. ... ...
>
> oRSv.PageSize = cMax
> TotalPages = oRSv.PageCount
> oRSv.AbsolutePage = RSPage
> ii = 1
>
> Do while not oRSv.EOF and not ii > cMax
> ... .... ...
> ... ... ...
>
> etc
>
> But now I've started to use the oRSv.getrows to speed things up and I

don't

> know the best way (or how for that matter) to page the data now that its

in

> an array rather than a oRSv....
>
> I want to keep using this array method so if anybody has any paging

routines

> to cover this, I would really appreciate it if you could post them on to

me.

>
> FYR, I am using ASP / ADO / MySQL DB, so I can't use any SProc paging
> routines.
>
> Thanks
>
> Laphan
>
>

[Laphan]

Thanks Aaron


Aaron [SQL Server MVP] <ten.xoc@dnartreb.noraa> wrote in message
news:OU95F#IWEHA.2176@TK2MSFTNGP11.phx.gbl...
[url]http://www.aspfaq.com/2120[/url]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:40d88469_3@127.0.0.1...

> Hi All
>
> I used to be able to page through data using the old:
>
> oRSv.CursorLocation = 3
> .. ... ...
> .. ... ...
>
> oRSv.PageSize = cMax
> TotalPages = oRSv.PageCount
> oRSv.AbsolutePage = RSPage
> ii = 1
>
> Do while not oRSv.EOF and not ii > cMax
> ... .... ...
> ... ... ...
>
> etc
>
> But now I've started to use the oRSv.getrows to speed things up and I

don't

> know the best way (or how for that matter) to page the data now that its

in

> an array rather than a oRSv....
>
> I want to keep using this array method so if anybody has any paging

routines

> to cover this, I would really appreciate it if you could post them on to

me.

>
> FYR, I am using ASP / ADO / MySQL DB, so I can't use any SProc paging
> routines.
>
> Thanks
>
> Laphan
>
>