Cfinput autosuggest help

Get Started
1

I running ColdFusion 8 Enterprise on Windows Server 2008 and SQL Server 2008. I am trying to perform a simple cfinput autosuggest for documents numbers from our database. Our documents numbers are 16 characters in length and I would like to only type in the right five characters if possible. When I type the right five characters into the input field, the autosuggest loading icon displays for a few seconds and then stops and no select list is displayed with suggestions. So, I tested the cfc using cfinvoke and I get the desired results. Any help is appreciated.

cfc:


<cfcomponent output="false">
     <!--- declare dsn --->
     <cfset THIS.dsn = "datasource" />
     <cffunction name="getData" access="remote" returntype="array">
          <!--- declare arguments --->
          <cfargument name="asTicket" type="any" required="No" default="13-16-" />
          <cfargument name="asSearch" type="any" required="No" default="" />
          <!--- declare variables --->
          <cfset var asData = "" />
          <cfset var asResult = ArrayNew(1) />
          <!--- perform query --->
          <cfquery datasource="#THIS.dsn#" name="asData">
               SELECT
                    tNumber
               FROM
                    cTicket
               WHERE
                    tNumber LIKE <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#ARGUMENTS.asTicket#%" />
                    AND RIGHT(tNumber, 5) = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#ARGUMENTS.asSearch#" />
          </cfquery>
          <!--- loop query reults --->
          <cfloop query="asData">
               <cfset arrayAppend(asResult, tNumber) />
          </cfloop>
          <!--- return result --->
          <cfreturn asResult />
     </cffunction>
</cfcomponent>

cfm:


<!--- Test cfc for proper operation --->
<cfinvoke component="as" method="getData" returnvariable="asResult">
     <cfinvokeargument name="asTicket" value="13-16-">
     <cfinvokeargument name="asSearch" value="00010">
</cfinvoke>

<cfdump var="#asResult#">

<!--- cfform with autosuggest cfinput --->
<cfform name="frmAutoSuggest" action="" format="HTML">
     <cfinput type="text" name="asSearch" id="asSearch"
          autosuggest="cfc:as.getData({cfautosuggestvalue})"
          autosuggestminlength="5" showautosuggestloadingicon="True"
          maxresultsdisplayed="30" />
</cfform>