3 Replies Latest reply on Jun 3, 2008 4:44 AM by Newsgroup_User

    recordset paging

    Level 7
      Im using DW 8 and classic ASP
      How do i create recordset paging like 1-10 | 11-20 | 21-30 | etc......?

      I'd also like to be able to change the order of the recordset results on the
      results page by links abpuve each column

      Like this

      orderID | date | Colour | etc...........

      Is this possible and if so how do you do it??

      Hope someone can help out here.

      Thanks in advance
      Andy


        • 1. Re: recordset paging
          Level 7
          > How do i create recordset paging like 1-10 | 11-20 | 21-30 | etc......?
          >
          > I'd also like to be able to change the order of the recordset results on
          > the results page by links abpuve each column
          >
          > Like this
          >
          > orderID | date | Colour | etc...........
          >
          > Is this possible and if so how do you do it??



          http://www.tom-muck.com/extensions/help/RecordsetNavigationSuite/

          http://www.dwzone-it.com/Extension/RecordsetPaging/How_Number.asp

          • 2. Re: recordset paging
            Level 7
            It's ok i found the solution
            For anyone else looking for similar here it is:


            <%
            Pagenumber_counter = 0
            For i = 100 to yourRS_total Step MM_size
            Pagenumber_counter = Pagenumber_counter + 100
            Pagenumber_PageEndCount = i + MM_size - 100
            if Pagenumber_PageEndCount > yourRS_total Then Pagenumber_PageEndCount =
            yourRS_total
            if i <> MM_offset + 100 then
            Response.Write("<a href=""" & Request.ServerVariables("URL") & "?" &
            MM_keepMove & "offset=" & i-100 & """>")
            Response.Write(Pagenumber_counter & "</a>")
            else
            Response.Write("<b>" & Pagenumber_counter & "</b>")
            End if
            if(pagenumber_PageEndCount <> yourRS_total) then Response.Write(" | ")
            next
            %>

            Andy


            "Andy" <andy@work.com> wrote in message
            news:g239ki$s06$1@forums.macromedia.com...
            > Im using DW 8 and classic ASP
            > How do i create recordset paging like 1-10 | 11-20 | 21-30 | etc......?
            >
            > I'd also like to be able to change the order of the recordset results on
            > the results page by links abpuve each column
            >
            > Like this
            >
            > orderID | date | Colour | etc...........
            >
            > Is this possible and if so how do you do it??
            >
            > Hope someone can help out here.
            >
            > Thanks in advance
            > Andy
            >


            • 3. Re: recordset paging
              Level 7
              Thanks Ted

              The TomMuck one looks great

              Andy


              "Ted Dawson" <nobody@home.anytime> wrote in message
              news:g23a4i$sh4$1@forums.macromedia.com...
              >> How do i create recordset paging like 1-10 | 11-20 | 21-30 | etc......?
              >>
              >> I'd also like to be able to change the order of the recordset results on
              >> the results page by links abpuve each column
              >>
              >> Like this
              >>
              >> orderID | date | Colour | etc...........
              >>
              >> Is this possible and if so how do you do it??
              >
              >
              >
              > http://www.tom-muck.com/extensions/help/RecordsetNavigationSuite/
              >
              > http://www.dwzone-it.com/Extension/RecordsetPaging/How_Number.asp