TryCF Gist

trycf-gist-1713518191852-42592963-108d-7e9a-e75e-c4081cc9f6a4.cfm

<cfscript>
numbersAsQuery = queryNew("id,en,mi", "integer,varchar,varchar", [
	[1,"one","tahi"],
	[2,"two","rua"],
	[3,"three","toru"],
	[4,"four","wha"]
])
</cfscript>

<cfquery name="numbersAsArray" dbtype="query" returntype="array">
    SELECT id, mi
    FROM numbersAsQuery
</cfquery>
<cfdump var="#numbersAsArray#">



<cfset numbersAsArray2 = numbersAsQuery.reduce((array, row) => array.append({id=row.id, mi=row.mi}), [])>
<cfdump var="#numbersAsArray2#">


<cfset numbersAsArray3 = numbersAsArray2.map((number) => {
    number.mi = "prefix_" & number.mi
    return number
})>
<cfdump var="#numbersAsArray3#">


<!---

<cfset local.branches = Model("Branch").find( // finds branch data (returns array)
	searchTerm = params.searchTerm,
	domain = cgi.server_name
).map((branch) => {
    return {
        branch_name = branch.branch_name,
        path = "/signup/branch/#branch.id#" // builds URL
    }
})>
--->