theideabulb
asked on
Return JSON from a CFC
I want to return login credentials in JSON format from a CFC. I am working on this, but don't think its right.
<cfcomponent name="loginCFC" displayname="loginCFC" output="false" hint="test login cfc for mobile app">
<cffunction name="getUser" access="remote" returnType="any" returnformat="JSON" output="false" hint="returns user info">
<cfargument name="username" type="string" default="">
<cfargument name="password" type="string" default="">
<cfset var qGetUser = "">
<cfquery name="qGetUser" datasource="#application.d atasource# ">
select user_id, user_id_code, fname, lname, email
from users
where lower(email) = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.username #">
and lower(password) = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.password #">
</cfquery>
<cfreturn qGetUser />
</cffunction>
<cfcomponent name="loginCFC" displayname="loginCFC" output="false" hint="test login cfc for mobile app">
<cffunction name="getUser" access="remote" returnType="any" returnformat="JSON" output="false" hint="returns user info">
<cfargument name="username" type="string" default="">
<cfargument name="password" type="string" default="">
<cfset var qGetUser = "">
<cfquery name="qGetUser" datasource="#application.d
select user_id, user_id_code, fname, lname, email
from users
where lower(email) = <cfqueryparam cfsqltype="cf_sql_varchar"
and lower(password) = <cfqueryparam cfsqltype="cf_sql_varchar"
</cfquery>
<cfreturn qGetUser />
</cffunction>
What exactly do you want returned?
ASKER
i want to return all the data that is in my query.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Because it should work
ASKER
HAHA! Your right it does work, i didn't try accessing it that way. I tried outputting it and dumping it. Thanks.. Easy points for you :)