Member Avatar for 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)#" />
  • 2 Contributors
  • 3 Replies
  • 149 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by arrgh
Member Avatar for arrgh

you're welcome.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.