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
