Unable to invoke CFC - Variable Q is undefined
I am using Ms sql and if I do this in the query editor :
select dbo.GetBranchNoFromIP('9.4.1.42')
I get a good result,
however in a remote object if I do the following:
<cffunction name="getCode" access="remote" returntype="string">
<cfargument name="localIP" type="string" required="yes">
<cfstoredproc procedure="GetBranchNoFromIP" datasource="#datasource#" returncode="true">
<cfprocparam type="in" cfsqltype="CF_SQL_VARCHAR" value="9.4.1.42">
<cfprocresult name="q">
</cfstoredproc>
<cfset flash.result=q>
<cfreturn flash.result>
</cffunction>
I get an error sayuing
faultCode:Server.Processing faultString:'Unable to invoke CFC - Variable Q is undefined.' faultDetail:''
ANy ideas what could be wrong?
