分页功能

 <cfset rowsperpage=10> <!---每页显示记录的数量----->
<cfparam name="URL.startrow" default="1" type="numeric">
<cfset totalrows=newarticle.Recordcount>
<cfset endrow=Min(URL.startrow+rowsperpage-1,totalrows)>
<cfset startRowNext=endrow+1>
<cfset startrowBack=URL.startrow-rowsperpage>

pagelist功能:

<cfsetting enablecfoutputonly="Yes"><!--- 压缩空白,提高性能 ---> 
<cfparam name="page" default=1 type="numeric"> <!--- 初始化本页页号 ---> 
<cfparam name="n" default=7 type="numeric"> <!--- 设置可以显示多少个页 ---> 

<cfset min = page-Int(n/2)> 
<cfset max = page+Int(n/2)> 

<cfif min LT 1> 
　<cfset max = max - (min-1)> 
　<cfset min = 1> 
</cfif> 

<cfif max GT Ceiling(newarticle.recordcount/rowsPerPage)> 
　<cfset min = min - (max - Ceiling(newarticle.recordcount/rowsPerPage))> 
　<cfset max = Ceiling(newarticle.recordcount/rowsPerPage)>
</cfif> 

<cfif min lt 1>
<cfset min=1>
</cfif> 

<!-- 首页 first-->
<cfif page NEQ 1>
<cfoutput>
<a href="#CGI.SCRIPT_NAME#?StartRow=1&Page=1" title="首页"><<</a>
</cfoutput>
</cfif> 

<!-- 页数 PAGELIST -->
<cfloop index="x" from="#min#" to="#max#">
<cfset nextpage=x*rowsperpage-(rowsperpage-1)>
<cfoutput>
<cfif page eq x>[#x#] <cfelseif nextpage LTE newarticle.recordcount>
<a href="#CGI.SCRIPT_NAME#?StartRow=#nextpage#&Page=#x#">#x#</a>
</cfif>
</cfoutput>
</cfloop> 

<!-- 末页 Last -->
<cfset laststartrow=newarticle.recordcount-rowsPerPage+1>
<cfif page NEQ MAX>
<cfoutput>
<a href="#CGI.SCRIPT_NAME#?StartRow=#laststartrow#&Page=#Ceiling(newarticle.recordcount/rowsPerPage)#">>></a>
</cfoutput>
</cfif> 

<!-- 上一页/下一页 -->
<cfoutput>
<CFIF startrowBack GT 0>
<cfif page EQ 1>
<CFSET NTback=1>
<cfelse>
<cfset NTback=page-1>
</cfif>
<a href="#CGI.SCRIPT_NAME#?startrow=#startrowback#&page=#NTback#">上一页</a>
</CFIF>
<CFIF startrownext LTE totalrows>
<cfset NTnext=page+1>
<a href="#CGI.SCRIPT_NAME#?startrow=#startrownext#&page=#NTnext#">下一页</a>
</CFIF>
</cfoutput>
<cfsetting enablecfoutputonly="no"><!--- 别忘记了关闭压缩空白功能 --->