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)#" />