Because me dba is taking a 4 day holiday weekend, and I'm just trying a cf solution.
;) >>-----Original Message----- >>From: Ken Wilson [mailto:[EMAIL PROTECTED]] >>Sent: Friday, November 29, 2002 12:26 PM >>To: CF-Talk >>Subject: RE: sum values in list >> >>Why not just return the totals as a part of your query? Let the database >>do >>it's job. >> >>Ken >> >> >>-----Original Message----- >>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] >>Sent: Friday, November 29, 2002 1:13 PM >>To: CF-Talk >>Subject: RE: sum values in list >> >> >>Thanks, Mike. It works(sorta). >> >>Below is my original code: >> >><cfloop query="qry_licenseInfo"> >> <cfif len(qry_licenseInfo.softwareUsers)> >> <cfset variables.totalSoftwareUsers = >>variables.totalSoftwareUsers + val(qry_licenseInfo.softwareUsers)> >> </cfif> >> <cfif len(qry_licenseInfo.softwareUsers)> >> <cfset variables.totalCurrentLicenses = >>variables.totalSoftwareUsers + val(qry_licenseInfo.currentLicenses)> >> </cfif> >> <cfif len(qry_licenseInfo.softwareUsers)> >> <cfset variables.totalRequiredLicenses = >>variables.totalSoftwareUsers + val(qry_licenseInfo.requiredLicenses)> >> </cfif> >> <cfif len(qry_licenseInfo.softwareUsers)> >> <cfset variables.totalRequiredUpgrades = >>variables.totalSoftwareUsers + val(qry_licenseInfo.requiredUpgrades)> >> </cfif> >></cfloop> >> >>Here's what I did with your suggestion: >> >><cfset variables.totalSoftwareUsers = >>arraySum(listToArray(valueList(qry_licenseInfo.softwareUsers)))> >><cfset variables.totalCurrentLicenses = >>arraySum(listToArray(valueList(qry_licenseInfo.currentLicenses)))> >><cfset variables.totalRequiredLicenses = >>arraySum(listToArray(valueList(qry_licenseInfo.requiredLicenses)))> >><cfset variables.totalRequiredUpgrades = >>arraySum(listToArray(valueList(qry_licenseInfo.requiredUpgrades)))> >> >>However, I've run into a snag. The query I'm working with is returning >>empty strings for some of the records. When this occurs, I am getting >>this >>for output: >>Total Software Users: 2.12453679578E-314 >> >>Is there something I can tweak? The single cfset is much more economical >>overhead wise, but I'm not sure what to change to get a "0" when nothing >>but >>empty strings are contained in the result set for each aggregate list. >> >>Thanks again for the help! >> >> >> >>Matthew P. Smith >>Web Developer, Object Oriented >>Naval Education & Training Professional >>Development & Technology Center >>(NETPDTC) >>(850)452-1001 ext. 1245 >>[EMAIL PROTECTED] >> >> >>>>-----Original Message----- >>>>From: Mike Townend [mailto:[EMAIL PROTECTED]] >>>>Sent: Friday, November 29, 2002 12:01 PM >>>>To: CF-Talk >>>>Subject: RE: sum values in list >>>> >>>>Try >>>> >>>>#ArraySum(ListToArray(myList))# >>>> >>>>HTH >>>> >>>> >>>> >>>>-----Original Message----- >>>>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] >>>> >>>>Sent: Friday, November 29, 2002 17:56 >>>>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 Get the mailserver that powers this list at http://www.coolfusion.com
