I'd like to find the sum of records in all catalog_id's. Each catalog_id has 25 to 50 or so records, but my code does not give me the total for all of them, just the total for each.
How should I modify my code to get the sum of all records?
<cfquery nane="OrderInfo" datasource="cdlib">
where area_id = #catalog_id#
Total records = #Ceiling(ArraySum(ListToArray(ValueList(file_count))))#