Basic Features:
· Provide page links for navigating through large record sets
· Maintains page “state” or continuity
· Provides user options for number of records to display
· Provides user options for how to sort the records
· Allows for text page links when searching for items alphabetically
· Allows for multiple paged record sets on any given template
· Customizable display format
· Easy to use
Sample Code:
<!--- A query to retrieve a list of all the countries in the world. --->
<cfquery name="Countries" datasource="MyDSN" dbtype="ODBC">
SELECT * FROM CountryList
ORDER BY CountryName
</cfquery>
<!--- <cf_PagerPro> placed between <cfquery> & <cfoutput>. --->
<cf_PagerPro query="Countries">
<!--- <cfoutput> with startrow & maxrows variables. --->
<cfoutput query="Countries" startrow="#Countries_startrow#" maxrows="#Countries_maxrows#">
#CountryName#<br>
</cfoutput>
Example of numbered links:
|
Items per page: 10, 20, 40 |
Showing 71 – 80 of 142 |
|
Sort By: Name, Population |
PREV 1.. 5, 6, 7, 8, 9, 10, 11 ..15 NEXT |
Example of Alphabetical Links:
|
Items per page: 10, 20, 40 |
Showing 71 – 80 of 142 |
|
Sort By: Name, Population |
PREV Afg, Arm, Bel, Bri, Cen, Cos, Eas NEXT |
Feel free to read the documentation (in PDF format). It is very descriptive, extensive and provides actual code examples of its use.