Problem When using Recordset paging

[Li]

Hi, guys,

I got a problem when trying to paging the recordset. the problem is
even I set the pagesize but the first page will always show all the
records and the number of records that shown on the second page will
always all records number minus pagesize. for example, if I have total
5 records and pagesize = 2, then first page will show 5 record and
second one will show 3 and the last page will show the last one.

any one have some idea about that condition?

Thanks a lot!

[Erland Sommarskog]

Re: Problem When using Recordset paging

Li (zlusc@hotmail. com) writes:[color=blue]
> I got a problem when trying to paging the recordset. the problem is
> even I set the pagesize but the first page will always show all the
> records and the number of records that shown on the second page will
> always all records number minus pagesize. for example, if I have total
> 5 records and pagesize = 2, then first page will show 5 record and
> second one will show 3 and the last page will show the last one.
>
> any one have some idea about that condition?[/color]

I guess you are using paging in ADO, but there are so many ways to do
paging, that rather I would like to know. Maybe you have some code to
share?


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp