Page through a record set.

[ironhide1975]

Trying to develop a listing page in Classic ASP and would like the ability to only show 50 records at a time and allow the user to page forward and back 50 records at a time. Is there an easy way to do this on the with ASP classic on the SQL end in where you can pass something to a SQL view or Stored procedure and tell it to only bring back the record rows you need?

 

[DotNetGnat]

see this link:

http://www.15seconds.com/issue/010308.htm

-DNG

 

[TheCandyman]

Personally i think this one is better

http://www.asp101.com/samples/db_paged_search.asp

but guess it's the same idea.

 

[ironhide1975]

Taking a look at both options, it seems like the stored procedure would be the best way to go. Is there anyway to specify in a SQL query where to start in the record rows? Or is it just assumed that at some point the entire dataset is going to be brought back and it's either up to the ASP code or a Stored Procedure to fill it out?

 

[DotNetGnat]

http://www.4guysfromrolla.com/webtech/062899-1.shtml

-DNG