OK, I think this should solve your empty string problem: <CFSET TheSum = ArraySum(ListToArray(ListChangeDelims(ValueList(qMyQuery.MyColumn),","," ")))>
Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com > -----Original Message----- > From: Smith, Matthew P -CONT(DYN) > [mailto:[EMAIL PROTECTED]] > Sent: Friday, November 29, 2002 12:56 PM > To: CF-Talk > Subject: sum values in list > > > I have a comma delimited list of integer values. Is there a > cf function > that will add all the values together? > > Or do I have to loop through the list adding each value to > get the sum? > > Matthew P. Smith > Web Developer, Object Oriented > Naval Education & Training Professional > Development & Technology Center > (NETPDTC) > (850)452-1001 ext. 1245 > [EMAIL PROTECTED] > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
