Hie. It's me again. I have a table (invalidName) that contains over 30,000 records. I want to display all these records for viewing & checking purposes. There is an ASP method by which I can use Paging to display these records in pages. Can anyone please enlighten me on how to start? And what would happen if the records are too many (Eg. > 10,000 records) & would it affect the layout of the ASP page?

* Love me for a reason; Let the reason be love *

__________________
* Love me for a reason; Let the reason be love *

Gosh people. Can I have a little bit of attention here??

* Love me for a reason; Let the reason be love *

One way to do this would be to run one query when you first hit your page to get the total number of records in your table, then run another query to return the required number of records for that page.

The number of pages can be calculated from the total records and you can then create links containing an offset parameter to allow selection of the next [n] records starting from that offset.

If you only select as many records as you need, too many record will not be an issue.

HTH,

Chris

Thanks Scott.. *smile*

* Love me for a reason; Let the reason be love *