Skip to main content
A
Adomacro
Inspiring
February 18, 2009
Question

Previous Next Button or Link

  • February 18, 2009
  • 2 replies
  • 436 views
Hello,

I got more than 50000 records in db to display.

I am looking for a efficient way to display using multiple pages using previous and next button or links.

Please help me with code.

I am using CFMX with SQL2005.

Waiting for your help.
    This topic has been closed for replies.

    2 replies

    A
    Anonymous
    February 19, 2009
    i have just solved the problem for a site of mine... it is a bit complicated but works good as long as you have consecutive id#s and few deleted or "hide" rows. it basicaly counts up or down and displays how many items you specify per page (less hidden or deleted)

    solving that problem next.

    send an email to snakester@live.com and i will send u the page and point you at the site.

    andy
    N
    Newsgroup_User
    Inspiring
    February 18, 2009
    From a similar thread in another discussion list.

    And remember, for server-side paging (next/prev buttons, etc), you should
    use my CFC - http://paginationcfc.riaforge.org/

    nathan strutz
    [Blog and Family @ http://www.dopefly.com/
    [AZCFUG Manager @ http://www.azcfug.org/



    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices