Can anyone help me out on how to limit the number of items shown on a

single page and allow the user to go from one page to the other? Any code

example or article url will be greatly appreciated. Thanks a lot in

advanced.

Syed 



--- 

FREE SOFTWARE DEVELOPMENT CODE, CONTENT, AND

INSIGHTS IN YOUR INBOX!

Get the latest and best C++, Visual C++, Java, Visual Basic, and XML tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb?s

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

Hi there,



The following article will give you a good idea on how to implement paging.



http://www.asp101.com/articles/recordsetpaging/index.asp







HtH



Imar





At 12:46 AM 12/26/2000 +0000, you wrote:

>Can anyone help me out on how to limit the number of items shown on a

>single page and allow the user to go from one page to the other? Any code

>example or article url will be greatly appreciated. Thanks a lot in

>advanced.

>Syed





---

FREE WEB DEVELOPMENT CODE, CONTENT, AND INSIGHTS

IN YOUR INBOX!

Get the latest and best HTML, XML, and JavaScript tips, tools, and 

developments from the experts.  Sign up for one or more of EarthWeb's

FREE IT newsletters at http://www.earthweb.com today!  

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com

I usually do it like this...



    rs1.open qry, cn2, 3, 1, 1

    rs1.PageSize

    if not(rs1.eof) then rs1.AbsolutePage=(page number here)



I then use a counter to exit a do loop like this...



counter=0

do until rs1.eof

    ...

    ...

    counter=counter+1

    if counter=20 then exit do

    rs1.movenext

loop



-Brad



> From: "Syed" <moin_ny@y...>

> Reply-To: "ASP Databases" <asp_databases@p...>

> Date: Tue, 26 Dec 2000 00:46:25 -0000

> To: "ASP Databases" <asp_databases@p...>

> Subject: [asp_databases] Limiting page

> 

> Can anyone help me out on how to limit the number of items shown on a

> single page and allow the user to go from one page to the other? Any code

> example or article url will be greatly appreciated. Thanks a lot in

> advanced.

> Syed 





--- 

NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?

Visit EarthWeb for the latest in IT Management, Software Development, 

Web Development, Networking & Communications, and Hardware & Systems.  

Click on http://www.earthweb.com for FREE articles, tutorials,

and discussions from the experts.

---

You are currently subscribed to asp_databases as: $subst('Recip.EmailAddr')

To unsubscribe send a blank email to leave-asp_databases-$subst('Recip.MemberIDChar')@p2p.wrox.com