Total: 27 Displaying: 1 - 10 Pages: 1 2 3 [>>]

[Mystery]

Can anyone point me to a script that will allow me to list x number of
records per page and give me a page selector and information like the one in
the subject header?

Thanks.

[Aaron Bertrand [MVP]]

www.aspfaq.com/2120


"Mystery" <my*****@barrys world.com> wrote in message
news:#p******** ******@TK2MSFTN GP09.phx.gbl...

Can anyone point me to a script that will allow me to list x number of
records per page and give me a page selector and information like the one in the subject header?

Thanks.

[Mr E]

Thanks, but that wasn't quite what I was looking for. I need it to
display something similar to :-

Total: 27 Displaying: 1 - 10 Pages: 1 2 3 [>>]

it should show no more than 3 pages. If there are more than this the
[>>] should then point to the next page, at which time when the page is
redrawn the information will change to :-

Total: 27 Displaying: 11 - 20 Pages: [<<] 2 3 4 [>>]

TIA
Mr.E

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[CJM]

I think Aaron's example lays it on a plate for you.... Short of actually
writing your code, what more can he do?

If this example doesnt fit, use it anyway... once you have master the basic
methods used, you can tweak the code to fit your desired model.
If you have any more specific questions, post another msg to this NG.

Chris

If you don't like his solution, try one of the other links...
"Mr E" <my*****@barrys world.com> wrote in message
news:OE******** *******@TK2MSFT NGP11.phx.gbl.. .

Thanks, but that wasn't quite what I was looking for. I need it to
display something similar to :-

Total: 27 Displaying: 1 - 10 Pages: 1 2 3 [>>]

it should show no more than 3 pages. If there are more than this the
[>>] should then point to the next page, at which time when the page is
redrawn the information will change to :-

Total: 27 Displaying: 11 - 20 Pages: [<<] 2 3 4 [>>]

TIA
Mr.E

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Peter Foti]

"Mr E" <my*****@barrys world.com> wrote in message
news:OE******** *******@TK2MSFT NGP11.phx.gbl.. .

Thanks, but that wasn't quite what I was looking for. I need it to
display something similar to :-

Total: 27 Displaying: 1 - 10 Pages: 1 2 3 [>>]

it should show no more than 3 pages. If there are more than this the
[>>] should then point to the next page, at which time when the page is
redrawn the information will change to :-

Total: 27 Displaying: 11 - 20 Pages: [<<] 2 3 4 [>>]

No offense, but that's kind of a crappy user interface. What if the user
wants something at the end of the list? I assume clicking on page 3 would
give you:

[<<] 2 3 4 [>>]

Essentially, you can only move 1 page at a time. That blows, especially if
there are 100 pages of results. You might want to reconsider the approach
you are taking. What you are asking for *is* recordset paging, so check out
the link that Aaron posted. Here's another you might find interesting:
http://www.4guysfromrolla.com/webtech/121298-1.shtml

Regards,
Peter Foti

[Mr E]

Thanks guys - I'll give it a go !! :-)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!