[loki421]

Ok, i kida follow you until the listQualify, but think i get what's going on here, thanks

Problem is i need to return the results to my Flex application as an array or arrayCollection (don't think there's much difference??)

So i had a go at trying to build the array in CF but it's giving me an error 'unable to invoke CFC, error executing database query'

i tried using

<cfreturn qData />"

<cfset myArray = {} /><!--- this goes at the top? --->

<cfset myArray.result = arrayNew(1) />
		
	<cfloop query="qData" >
		<cfset myArray.temp = {} />
		<cfset myArray.column1 = qData.column1 />
		<cfset myArray.column2 = qData.column2 />
		<cfset myArray.column3 = qData.column3 />
		<cfset arrayAppend(myArray.result,myArray.temp) />
	</cfloop>
		
	<cfreturn myArray.result />

Any ideas how i could get this back to Flex as an array? Both ways are giving me errors

Hope you can help