Tim Buntel (tim@buntel.com)
February 10, 1999

Last Modified: 
DATE         AUTHOR                         MODIFICATION
==========   ===========                   =============================
5/12/99      Chris Funk Maptech Inc        MODIFIED ATTRIBUTES:  
                                           DisplayCount = "Integer"      Default - 10  
                                       
									       ADDED ATTRIBUTES: 
                                           CountOutput = "String"         Default - Counter 
			                               FirstLink = "String"           Default - First 
			                               NextLink  = "String"           Default - Next
			                               PreviousLink = "String"        Default - Previous
			                               LastLink = "String"            Default - Last
			                               InactiveFirstLink ="String"    Default - FirstLink font "gray" 
			                               InactiveNextLink ="String"     Default - NextLink font "gray"
			                               InactivePreviousLink ="String" Default - PrevoiusLink font "gray"
		                                       InactiveLastLink ="String"     Default - LastLink font "gray"
			
										   REMOVED ATTRIBUTES: 	
										   Display Font ="Arial"				 

CF_prior_next displays a set number of records in a query and allows the user to move 
forward and backwards through the set with four options; First, Prior, Next, Last.

Usage: 

<cfquery name="sales" datasource="Coffee Valley">
SELECT      Month, Sales
FROM         Sales
WHERE 	Sales > #salesfig#
</cfquery>

<CFSET MaxRows = 15>

<CF_prior_next Count="#sales.Recordcount#"
		   	DisplayCount="#MaxRows#"
		   	
                        ThisPage="next_recs.cfm"
		   	ExtraURL="salesfig=#salesfig#">
         	        CountOutput = "MycountResults" 
			
			FirstLink = "Go First"
			NextLink = "Go Next"
			PreviousLink = "Go Previous"
			LastLink = "Go Last"
			InactiveFirstLink = '<font color = "red">Go First</font>'
			InactiveNextLink = '<font color = "red">Go Next</font>'
			InactivePreviousLink = '<font color = "red">Go Previous</font>'
			InactiveLastLink = '<font color = "red">Go Last</font>'

<CFOUTPUT>

<TABLE> 
<TR>
  <TD>#LastLink#</TD> 
  <TD>#PreviousLink#</TD>    << DYNAMIC HEADER 
  <TD>#NextLink#</TD> 
  <TD>#FirstLink#</TD>
</TR>
</TABLE>
</CFOUTPUT>

<CFOUTPUT>#MycountResults#</CFOUTPUT> << DISPLAYS THE COUNTER 			
<cfoutput query="sales" startrow=#FromRec# maxrows=#MaxRows#>


#Month#, #Sales#<br> 

</cfoutput>

Attributes:
1. Count: The Record Count of the query that you are outputting

2. DisplayCount: DisplayCount is the number of records to display per page.  As in the above example, it can be set as a variable or it could be written into the tag and cfoutput.  **IMPORTANT: The maxrows parameter in the cfoutput tag MUST match the DisplayCount value in the CF_prior_next tag.

3. ThisPage: The name of the cfm document on which CF_prior_next is placed.

4. ExtraURL: as the "First, Prior, Next, and Last" links call the page again and again, any other variables needed for the template may be included in this attribute.  String multiple variables together with an ampersand (&) i.e. ExtraURL="var1=x&var2=y"
 
5. "FirstLink, NextLink, PreviousLink, LastLink":  String values the represent text or HTML that are only displayed when the link is INACTIVE.       
 
6. "inactiveFirstLink, inactiveNextLink, inactivePreviousLink, inactiveLastLink": String values the represent text or HTML that are only displayed when the link is INACTIVE 
 
7. CountOutput: this will display the number of results returned as a single var