<cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfparam name="PageNum_art" default="1">
<!--- 这个分页程序需要修改 queryName 和 datasource --->
<cfquery name="art" datasource="BusinessPower">
SELECT * FROM provider
</cfquery>
<cfset MaxRows_art=2>
<cfset StartRow_art=Min((PageNum_art-1)*MaxRows_art+1,Max(art.RecordCount,1))>
<cfset EndRow_art=Min(StartRow_art+MaxRows_art-1,art.RecordCount)>
<cfset TotalPages_art=Ceiling(art.RecordCount/MaxRows_art)>
<cfset QueryString_art=Iif(CGI.QUERY_STRING NEQ "",DE("&"&XMLFormat(CGI.QUERY_STRING)),DE(""))>
<cfset tempPos=ListContainsNoCase(QueryString_art,"PageNum_art=","&")>
<cfif tempPos NEQ 0>
  <cfset QueryString_art=ListDeleteAt(QueryString_art,tempPos,"&")>
</cfif>

<table border="0">
  <tr>
    <th scope="col">providerId</th>
    <th scope="col">providerName</th>
  </tr>
  <cfoutput query="art" startrow="#StartRow_art#" maxrows="#MaxRows_art#">
    <tr>
      <td>#art.providerId#</td>
      <td>#art.providerName#</td>
    </tr>
  </cfoutput>
</table>
<p> [<a href="<cfoutput>#CurrentPage#?PageNum_art=1#QueryString_art#</cfoutput>">&lt;&lt; First</a>] [<a href="<cfoutput>#CurrentPage#?PageNum_art=#Max(DecrementValue(PageNum_art),1)##QueryString_art#</cfoutput>">&lt; Previous</a>] [<a href="<cfoutput>#CurrentPage#?PageNum_art=#Min(IncrementValue(PageNum_art),TotalPages_art)##QueryString_art#</cfoutput>">Next &gt;</a>] [<a href="<cfoutput>#CurrentPage#?PageNum_art=#TotalPages_art##QueryString_art#</cfoutput>">Last &gt;&gt;</a>] </p>