Well, here is what I came up with, and this is working fine now.
I setup an array to hold my pay descriptions and classes:
<cfset paycodes = arrayNew(2) />
<cfset paycodes[1][1] = 'Holiday Pay' />
<cfset paycodes[1][2] = 'HOLI' />
<cfset paycodes[2][1] = 'Safety Bonus' />
<cfset paycodes[2][2] = 'SAFE' />
Then I looped it in this output block:
<!---// Output all ancillary pay by looping through pay type
array defined above //--->
<cfloop from="1" to="#arrayLen(paycodes)#" index="i">
<cfoutput>
<TR>
<TD class="dataHead">#paycodes[i][1]#</TD>
<cfloop from="0" to="-4" step="-1" index="m">
<cfparam name="getTemp.Amt" default="0">
<!---// Query this month / year's
holiday pay //--->
<cfquery name="getTemp" dbtype="query">
SELECT SUM(GrossPay) as Amt
FROM getData
WHERE payClass = '#paycodes[i][2]#'
AND payYear =
#dateFormat(dateAdd("m", m, now()), "YYYY")#
AND payMonth =
#dateFormat(dateAdd("m", m, now()), "MM")#
</cfquery>
<TD class="data" align="right"
<cfif listFind('0,-2,-4', m)>
bgcolor="##CCCCCC"</cfif>>#dollarformat(getTemp.Amt)#</TD>
</cfloop>
</TR>
</cfoutput>
</cfloop>
Working good now!
Thanks,
Chris Peterson
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267792
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
