Queries are treated like Arrays in CF. Try this: #ArraySum(QueryName['columname'])#
-Cameron ----------------- Cameron Childress Sumo Consulting Inc. --- cell: 678-637-5072 aim: cameroncf email: [EMAIL PROTECTED] > -----Original Message----- > From: Kris Pilles [mailto:[EMAIL PROTECTED]] > Sent: Monday, June 03, 2002 2:48 PM > To: CF-Talk > Subject: Sum Help > > > Ok.. I;ve got myself confused here... > > I have a table that has some numbers lets say 5 records (50, > 45, 33, 23, > 12) now I want to be able to select * from that table (not a problem). > But I need to sum those numbers so that I can output > sum(50+45+33+23+12)... > > How can I do this??? > > Is there an easy way am I forgetting something??? > > KP > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
