Steve, You can treat query columns just like they are arrays in ColdFusion (sort of). This assumes that you are NOT getting the SUM as a SQL aggregate:
http://www.bennadel.com/blog/167-Calling-Array-Functions-on-ColdFusion-Q uery-Columns.htm OR http://www.bennadel.com/index.cfm?dax=blog:167.view Hope that helps. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Steve Good [mailto:[EMAIL PROTECTED] Sent: Friday, January 26, 2007 5:59 PM To: CF-Talk Subject: Getting the sum of all rows for one column I'm back with another dumb question. I am trying to get the sum of an expenses column for all rows. I have no clue how to go about this. I played around with cfloop a little bit, but just ended up adding the current row's column to itself, then moving on to the next row and doing the same. I'm sure it's an easy thing to do, but for the life of me I can't figure it out. Thanks in advance for the help :) ~Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267896 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
