Looping over a Query Set as an Array
ColdFusionOne day, not too long ago, my buddy Fro showed me a cool way to sum up values of a query set using the arraySum function in ColdFusion. Say you have a query that returns all of your baseball cards and their respective values. Well in this example you can do something like this
arraySum(qGetCards['cardValue'])
That function will sum up all of the "cardValue" values returned from the query.
What I ran into today was the fact that I didn't want to add up all the values, just part of them. For this I wrote the following script. It is looping through a query and only summing the amount where there is no expirationDate.
Hope this helps someone, somewhere!
Good Day,
Ryan
Dave Shuck said:
No, I altered the conditional statment too:
(i=1;i<=arrayLen(sqlQry['amount']);i++)
I know it is silly, but that syntax is one of the things I am most excited about!
(i=1;i<=arrayLen(sqlQry['amount']);i++)
I know it is silly, but that syntax is one of the things I am most excited about!
Ryan Everhart said:
ohh right, the <= instead of the LTE... but what about this line, can I use this line in my current code? With the += in there?
variables.currentTotal += sqlQry['amount'][i];
variables.currentTotal += sqlQry['amount'][i];
Loading....