Using ArraySum on a Query Column

[sevex]

I'm trying to use arraysum with a query column to get the sum of all the values, but it just sees the first value, instead of an array. Is there some special way to do this?

My code:
<cfquery name=&quot;get_results1&quot; datasource=&quot;xxx&quot;>
SELECT DISTINCT(q1), COUNT(q1) AS q_count FROM survey GROUP BY q1
</cfquery>

(This returns all unique records, and how many of each there are, I want a total so I can find %)

<cfset total = #ArraySum(get_results1.q_count)#>

(This is giving me an error, saying the parameter is &quot;1&quot; and not an array)

Thanks in advance for any help!

 

[Silvano]

try using SUM aggregate function:

SELECT DISTINCT(q1), SUM(q1) AS q_count FROM ... Sylvano
dsylvano@hotmail.com

 

[CFHub]

You can use ArraySum() although the SQL method will likely be faster.

#ArraySum(get_results1['q_count'])#

 

[sevex]

Thanks CFHUb, that worked great.

Thanks WWebSpider as well, although I couldn't use that method, because I needed individual counts for each distinct, as well as a total.