How to output cfquery to array?

Depending on the version of CF you're working with there's a very simple solution in CF2021 on. You could always just use the returnType option in your query declaration. For instance with the CFScript version:

QueryExecute("SELECT foo FROM bar ,{},{returnType="array"});

or the CFTag version:

<cfquery name="thisQry" datasource="#application.theDSN#" result="results" returntype="array">
SELECT foo FROM bar
</cfquery>

The returnType="array" attribute, which allows the CFQuery tag and the queryExecute() function to return an Array-of-Structs instead of a Query object. This might be the simplest approach.

Here's yet another solution, for those on CF2018 (not CF2016 or earlier), indeed a one-liner, using the reduce and fat arrow functional programming constructs, which Adobe offered starting in CF2018 update 5 (in Sep 2019). 

David Byers did a blog post showing the concept and code, and here is a still simpler working example I just created on the cffiddle site. 

[I had originally written that this was also in CF2016 update 12, based on what David had written in his post. But right after posting my comment here, I thought to do a check against CF2016's latest update--as offered on that cffiddle site--and sadly it did NOT work. And my looking at docs elsewhere about these fat arrow/lambda's, they indeed mention only CF2018.)

Anyway, to show it here more simply in the context of pirlo89's original post and code above (which granted is from 2015), it would be (using tags as they did):

<cfset myarray=qryCustomers.reduce((result, row) => {result.append(row);return result;}, []);

Sure, that's ugly and even obtuse to those not familar with functional programming (which is supposed to make things "simpler"). But bottom line, it's literally as simple as appending ".reduce((result, row) => {result.append(row);return result;}, []);" to any queryname.

Hope that helps folks on CF2018, until they may get to 2021 where it's that simpler returntype="array" that I mentioned yesterday. 🙂

I created the following until hopefully Adobe ColdFusion might adopt a cool returntype attribute feature that Lucee offers to turn the query type into an array or structs.  Until then or maybe never:

<cfscript>
queryToAOS(yourQueryVariableHere);

function queryToAOS (qryData) {
	local.aos = [];
	for (local.i = 1; local.i <= qryData.recordCount; local.i++) {
		local.aos.append(queryGetRow(qryData, local.i));
	}
	return local.aos;
}
</cfscript>