cfautosuggest and cfc

[danarashad]

I am having a weird issue. I am using cfautosuggest, when I type child into the search box the cfc should return "Other Minor Child in Custody,Grandchild, Great Grandchild", but it doesn't. The weird part is when the query runs I do a dump in the cfc and it does return "Other Minor Child in Custody,Grandchild", but when json takes over to return it back to the screen, I get nothing. has anyone ran into this issue?

SELECT question
FROM lookup
Where question like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#trim(arguments.search)#%" />
		and lookupname=<cfqueryparam cfsqltype="cf_sql_integer" value="#trim(arguments.keyname)#">
        and responsetype= <cfqueryparam cfsqltype="cf_sql_varchar" value="#ucase(arguments.responseid)#" />

[arrgh]

It's caused by the default YUI settings (javascript lib). It only returns stuff that start with whatever you typed. See the bottom comments for how to fix it.
http://www.coldfusionjedi.com/index.cfm/2007/7/23/A-Gotcha-with-Auto-Suggestions-in-ColdFusion-8

[danarashad]

It's caused by the default YUI settings (javascript lib). It only returns stuff that start with whatever you typed. See the bottom comments for how to fix it. http://www.coldfusionjedi.com/index.cfm/2007/7/23/A-Gotcha-with-Auto-Suggestions-in-ColdFusion-8

Thank you for the information.

[arrgh]

you're welcome.