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)#" />
7 Years
Discussion Span
Last Post by arrgh
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.