Hot to sum all the elements in an array 2

[ranta]

HI,

Is there any built in function within ASP that will allow you to sum all the elements in an array or do you have to loop through manualy?

 

[onpnt]

you mean add them all up right?

I do not believe so. A loop will most likely be needed.

_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com

 

[Mr3Putt]

... I can't remember what the equivalent to the javascript "eval(expression)" is... but, in javascript, you could write:

var addStr = arrayVar.join("+");
var arraySum = eval(addStr);

So, if your arrayVar looked like: 1, 2, 3, 4...

your addStr would look like 1+2+3+4...

Evaluate the string and it ends up: 10.

I'm pretty sure there's a VBScript equivalent to "eval()", but someone else will need to point it out. Hope that helps a bit.

 

[onpnt]

cool idea Mr3Putt

Dim val
Dim myarray : myarray = array("1","2","3&quot
val = eval(join(myarray,"+&quot)
response.write val

_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com

 

[Mr3Putt]

Thanks, onpnt,

It's less code than looping, anyway.. but it doesn't allow for any error-handling. So, if your array contains non-numeric or null values... it'll die.

Other than those caveats, it oughta work.

 

[Mr3Putt]

Also, I wonder how this method would handle negative values, like:

dim myArray : myArray = array("1","-2","3","4")

perhaps the join statement should be updated to look like:

dim val
val = eval("(" & join(myArray,")+(") & ")")

So, the "eval" function would receive a string like:

(1)+(-2)+(3)+(4)

...which might be a better idea.