We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now
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"> select * from areas where area_id = #catalog_id#</cfquery ><cfoutput query="OrderInfo"> Total records = #Ceiling(ArraySum(ListToArray(ValueList(file_count))))#</cfoutput>