how do you control paging

[nadskram]

i am just curious of industry standards, like there is such a thing

but how do you limit the results shown on a page

the way i see it, there are 3 approaches
1.
select all and just show the range through looping and begin/end values, i.e show records 11 - 20

2.
set page size and page on recordset

3.
get specific record count through sql statement

are there others?
advantages?

just curious

 

[Veep]

http://www.aspfaq.com/show.asp?id=2120

 

[nadskram]

the first method posted on that site is the same as my number 1, kinda
it retrieves all the records and then does a recordset.move to get to the first record

is that what you do veep?

the second one is definetly more in depth using a stored proc to only get the ones you want

anyone else have a favorite method?

 

[Veep]

If I have a SQL Server to work with I use the second method. It's a little faster. Otherwise, the first.