In my flex 2 application, I'm trying to call to a CFC and return a
query.. I'm getting an error stating.. "faultCode:Client.Input
faultString:'unexpected parameter 'nxx' found in input arguments.'
faultDetail:null"
This is what my webservice call looks like..
<mx:WebService id="myWS"
useProxy="false"
wsdl="http://localhost:8300/npanxx/npanxx.cfc?wsdl";
showBusyCursor="true">
<mx:operation name="listRecords"
result="handleQueryResult(event)"
fault="Alert.show(event.fault.message)" resultFormat="object">
<mx:request>
<npa>{txtNPA.text}</npa>
<nxx>{txtNXX.text}</nxx>
<data>{txtDATA.text}</data>
</mx:request>
</mx:operation>
</mx:WebService>
and my CFC
<cfcomponent output="false" name="npanxx">
<cffunction name="listRecords" access="remote" returnType="query"
output="false">
<cfset var npa = '' />
<cfset var nxx = '' />
<cfset var data = '' />
<cfset var fooQ = '' />
<cfquery name="fooQ" datasource="npanxx_prod">
SELECT npa, nxx
FROM npanxx
where npa = <cfqueryparam cfsqltype="cf_sql_numeric"
value="#npa#" />
and nxx = <cfqueryparam cfsqltype="cf_sql_numeric"
value="#nxx#" />
and t_strt < <cfqueryparam cfsqltype="cf_sql_varchar"
value="#data#" />
and t_finish > <cfqueryparam cfsqltype="cf_sql_varchar"
value="#data#" />
</cfquery>
<cfreturn fooQ>
</cffunction>
</cfcomponent>
I'm not sure what I'm doing wrong, can someone assist?
Thanks
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
