Skip to main content
Known Participant
September 9, 2013
Question

auto sugesstion

  • September 9, 2013
  • 0 replies
  • 367 views

Hi there,

I need to pass the companyId into the cfc but i keep gettting an error, does any know?- thanks

You cannot specify more arguments to a CFC function than it declares.
Error parsing bind cfc:cfc.query.getCustName({cfautosuggestvalue},{request.compERP.compID})

.cfm


<cfinput type="text" name="cust_name" id="cust_name" size="50" autosuggest="cfc:cfc.query.getCustName({cfautosuggestvalue},compID=request.defaultcompId.compID})" >

.cfc

<cffunction name="getCustName" access="remote" returntype="array">
    <cfargument name="search" type="any" required="yes" default="" />

  <cfargument name="CompID" type="numeric" required="yes" />


 
  <!--- Define variables --->
  <cfset var qCust="">
  <cfset var result=ArrayNew(1)>
  <cfquery name="qCust" datasource="devlivery"  >
   select cust_name from customer
   WHERE lower(cust_name) LIKE lower('#ARGUMENTS.search#%')
            and compID = #arguments.id#
  </cfquery>
  <cfloop query="qCust">
  <cfset ArrayAppend(result, cust_name)>
  </cfloop>
 
   <!--- And return it --->
    <cfreturn result>
</cffunction>

    This topic has been closed for replies.