Re: Showing data from a cfquery.

[Eric Haskins]

Here is some of my code


<cfif IsDefined("attributes.pageNumber")>
            <cfset pageNumber = attributes.pageNumber>
</cfif>
<cfparam name="pageNumber" default="1">
<cfset k = 30>
<cfset startNumber = Evaluate((k * pageNumber) - (k - 1))>
<cfset endNumber = startNumber + k - 1>
<cfset pageTotal = "#ceiling(qry_reqSrcResults.recordCount/k)#">
<center><h2>Photo Requests</h2></CENTER>
<div align="center">
Results:&nbsp;
<a
href="#self#?fuseaction=#XFA.usersub#&pageNumber=1&manufacturer_id=#attributes.manufacturer_id#"><<</a>
&nbsp;
 <cfloop from="1" to="#pageTotal#" index="i">
 <cfif i NEQ pageNumber>
       <a
href="#self#?fuseaction=#XFA.usersub#&pageNumber=#i#&manufacturer_id=#attributes.manufacturer_id#">#i#</a>
 <cfelse>
  <font color="red">#i#</font>
 </cfif>

 &nbsp;
</cfloop>
<a
href="#self#?fuseaction=#XFA.usersub#&pageNumber=#pageTotal#&manufacturer_id=#attributes.manufacturer_id#">>></a>
</div>

I just quickly hacked some code I had. I woul probably add logic to grey out
the >>  and << depending on the page your on


-- 
~Eric


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270317
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4