just curious... isn't it more efficient to have the database perform this calc?
~ dina ----- Original Message ----- From: "Cameron Childress" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 2:17 PM Subject: RE: Sum Help > 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 > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
