<cfcomponent><cfsetting showdebugoutput="no"><cffunction access="remote"  name="doClientLoginJson" output="yes" returntype="void"><cfargument name="email" required="yes"><cfargument name="pw" required="yes"><cfset session.userID = 100><cfquery name="getClient" datasource="cdb">SELECT * FROM tblClients WHERE username =  <cfqueryparam value="#arguments.email#" cfsqltype="CF_SQL_VARCHAR" maxlength="40"> AND password = '#hash(arguments.pw)#'</cfquery><cfif getClient.recordcount><cfset returnData =  '{"success":"true2","clientId":"#getClient.clientid#"}'><cfelse><cfset returnData = '{"success":"true2","clientId":"0", "msg":"login failed"}'></cfif>#variables.returnData#</cffunction></cfcomponent>