<!--- set variables for pagination ---> <cfparam name="attributes.rows" default="10"> <cfparam name="url.next" default="0"> <cfset variables.start = 1> <cfset variables.next = attributes.rows> <cfif url.next GT 0> <cfset variables.start = url.next + 1> <cfset variables.next = url.next + variables.next> </cfif> <!--- *** for recordcount display. If recordcount is less than display count, reset display count *** ---> <cfif variables.next GT rs_MyQuery.recordcount> <cfset variables.next = rs_MyQuery.recordcount> </cfif> <table width="100%" align="center"> <tr align="center"> <td colspan="18" class="text"><b><cfoutput>Displaying #variables.start# - #variables.next# of #rs_MyQuery.recordcount# records </cfoutput></b></td> </tr> <tr align="center"> <td class="text"> <cfif url.next GT 0> <a href="<cfoutput>#cgi.script_name#?next=#evaluate(url.next - attributes.rows)#</cfoutput>">Previous</a><cfelse>Previous</cfif> - <cfif variables.next LT rs_MyQuery.recordcount> <a href="<cfoutput>#cgi.script_name#?next=#variables.next#</cfoutput>">Next</a> <cfelse>Next </cfif> </td> </tr> </table> <!--- output the results ---> <cfoutput query="rs_directory" startrow="#variables.start#" maxrows="#attributes.rows#"> <!--- data here ---> </cfoutput>