tracker issue : CF-3037465

select a category, or use search below
(searches all categories and all time range)
Title:

Bug 75364:(Watson Migration Closure)ER for: Adding 'ignoreUndefined=""' attribute to arraySum()

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Aaron Neff / Aaron Neff (Aaron Neff)

Created: 02/07/2009

Components: Language, Functions

Versions: 9.0

Failure Type: Enhancement Request

Found In Build/Fixed In Build: 0000 /

Priority/Frequency: Normal / Unknown

Locale/System: English / Platforms All

Vote Count: 1

Listed in the version 2016.0.03.300466 Issues Fixed doc 
Problem:

ER for: Adding 'ignoreUndefined=""' attribute to arraySum(). Because, currently, arraySum() does not support undefined elements. This would offer a shortcut to 'arraySum(listToArray(arrayToList()))' This new attribute would be optional, boolean, and default to 'false' for backward compatibility.
Method:

Examples. Please see "<--- Proposal" notes.

<cfscript>
  //query example
  myQuery = queryNew("myQueryColumn", "integer");
  queryAddRow(myQuery, 3);
  myQuery.myQueryColumn[1] = 1;
  myQuery.myQueryColumn[3] = 3;

  dump(var=arraySum(listToArray(arrayToList(myQuery['myQueryColumn']))));
  //dump(var=arraySum(myQuery['myQueryColumn'], true)); <--- Proposal
  writeOutput('<br />--<br />');
  //array example
  myArray = arrayNew(1);
  myArray[1] = 1;
  myArray[3] = 3;
  dump(var=arraySum(listToArray(arrayToList(myArray))));
  //dump(var=arraySum(myArray, true)); <--- Proposal
</cfscript>
Result:

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3037465

External Customer Info:
External Company:  
External Customer Name: Aaron Neff
External Customer Email: 3D1D17B03C844EBF992001AC
External Test Config: 02/07/2009

Attachments:

Comments:

As was alluded to on the forums, I don't think we need the extra parameter, empty elements should be ignored as a matter of course. +1 vote though. -- Adam
Vote by External U.
24046 | November 10, 2011 07:16:01 PM GMT
I would like to modify my ticket to be Adam's suggestion: arraySum() should simply ignore empty elements. And now that I think about this again, it seems like a bug. arraySum() shouldn't trip over these empty elements. Thanks!, -Aaron
Comment by External U.
24045 | September 12, 2015 01:33:00 AM GMT