cfquery to array

How would you populate an array from a query?

 

Here's is one way you could do it:

<cfquery name="Yada" ....>
select FieldName1, fieldName2, FieldName3 from Table Where condition order by Sort
</cfquery>

<cfset AllOfField1 = ValueList(Yada.FieldName1,",")>
<cfset Field1Array = ListToArray(AllOfField1)>


HTH

 

Are there any user defined functions out there to do this all in one step rather than two?

 

Well you could in fact do this:

<cfset FieldIArray = ListToArray(ValueList(Yada.FieldName1,","))>

HTH