Ummm.....in this scenario, using Int() is worse than using Round(). At least with Round you have a 50% chance of getting the remainder, using Int() drops that down to 0%.
-----Original Message----- From: paul smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 12, 2002 11:03 AM To: CF-Talk Subject: RE: Prev 1 2 3 ... Next Thanks! I think I need to use Int instead of Round. If I have 73 results, I only want to display links to 1 2 3 4 5 6 7, not to 1 2 3 4 5 6 7 8 In addition, to get the Google format, I need to include Previous/Next. Finally, I need to display the current page with no link. The following is my try at matching the Google format (not tested). (Why follow Google? Very good usability research.) best, paul ========================================= <cfset perpage = 10> <cfset pagesum = Int(yourqName.recordcount/perpage)> <cfset startrow = 1> <cfset currentpage = 1> <cfif pagesum GT 1> <cfif currentpage GT 1> <cfset prevstart = startrow - perpage> <cfoutput><a href="result.cfm?startrow=#prevstart#&results_per_page=#perpage#">Previous< /a> </cfoutput> </cfif> <cfloop index="link_num" from="1" to="#pagesum#" step="1"> <cfoutput> <cfif link_num IS currentpage> #link_num# <cfelse> <a href="result.cfm?startrow=#startrow#&results_per_page=#perpage#">#link_num#< /a> </cfif> </cfoutput> <cfset startrow = startrow + perpage> <cfset currentpage = currentpage + 1> </cfloop> <cfset nextstart = startrow + perpage> <cfif nextstart LT yourqName.RecordCount> <cfoutput><a href="result.cfm?startrow=#nextstart#&results_per_page=#perpage#">Next</a>&n bsp;</cfoutput> </cfif> </cfif> =========================== At 09:16 AM 12/12/02 -0600, you wrote: >Here's the basics given a recordcount. A difference from WG's response >is the use of Ceiling() instead of Round(). Why? Because if you get 73 >results with a perpage setting of 10 (73/10=7.3). With Round, it will >round to the nearest integer giving you 7 pages. So you will have only >70 of your 73 results displayed. This way, it gives you 8 pages with >only 3 results displayed on the last page. > >Have fun! > ><cfset perpage = 10> ><cfset pagesum = Ceiling(yourqName.recordcount/perpage)> > ><cfset startrow = 1> > <cfif pagesum GT 1> > <cfloop index="link_num" from="1" to="#pagesum#" >step="1"> <cfoutput><a >href="result.cfm?startrow=#startrow#&results_per_page=#perpage#">#link_ >num#< >/a> </cfoutput> > <cfset startrow = startrow + perpage> > </cfloop> > </cfif> > >-----Original Message----- >From: paul smith [mailto:[EMAIL PROTECTED]] >Sent: Thursday, December 12, 2002 7:32 AM >To: CF-Talk >Subject: Prev 1 2 3 ... Next > > >Google results offer links like the subject. > >Given RecordCount from a query, is there a tag to create links like the >subject? > >Or a script? > >best, paul > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
