hi . I have written a cfc which has a function which has a query and I want the result of that query to be returned as an array and I have specified the return type of the function to "Array" . I hope I can then use that Array in my Flex application . but I can't return the right value and CF gives me error . my cfc is as follow:
<cfcomponent> <cfprocessingdirective pageencoding="utf-8"> <cfset setEncoding("form","utf-8")> <cfset setEncoding("url","utf-8")> <cfcontent type="text/html ; charset=UTF-8"> <cffunction name="login" access="remote" returntype="Array"> <cfargument name="username" type="string" required="true"> <cfargument name="password" type="string" required="true"> <cfquery name="qCheck" datasource="Library"> select username,password from Users where username=<cfqueryparam value=#username# cfsqltype="cf_sql_varchar"> AND password=<cfqueryparam value=#password# cfsqltype="cf_sql_varchar"> <cfreturn qCheck> </cffunction> </cfcontent> </cfcomponent> ------------------------------ I'll be appreciated if you can help me with this . thanks . ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339205 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm