CFSearch Criteria

[ecintern]

I am trying to use a string variable NoCommas as the search criteria for a CFSearch. Everytime I try it I get an invalid criteria error. I am using it in the following way

<cfif #Form.AllFields# is not &quot;&quot;>
<cfset NoPeriods = &quot;<cfoutput>#Replace(Form.AllFields,&quot;.&quot;,&quot;*&quot;, &quot;all&quot#</cfoutput>&quot;>
<cfoutput>#NoPeriods#</cfoutput>
<cfset NoCommas = &quot;<cfoutput>#Replace(NoPeriods,&quot;,&quot;,&quot;\,&quot;, &quot;all&quot#</cfoutput>&quot;>
<cfoutput>#NoCommas#</cfoutput>

<CFSEARCH NAME= &quot;GetAllFields&quot;
COLLECTION= &quot;HolmpsonSearchAll&quot;
TYPE= &quot;explicit&quot;
CRITERIA= &quot;#NoCommas#&quot;>

I don't understand why this should cause an error. Anyone know?

Thanks ahead of time

ECintern

 

[GunJack]

Hey ECintern,

It's been a while since I've used <cfsearch> but my initial suspicion is that you need to remove the &quot;<cfoutput>&quot; strings from your <cfset> statements. This will become part of your search criteria and may be causing the problem. If you are wanting the search to specifically look for &quot;<cfoutput> strings, I believe you will have to escape the &quot;<&quot; and &quot;>&quot; characters as these are special characters used by <cfsearch>.

If this doesn't help, let me know and I'll look up some info on the <cfsearch> tag and try to narrow it down.

GJ

 

[CFHub]

There are several &quot;bad&quot; charachters that make CFSEARCH &quot;barf&quot;.

There is a custom search and replace here you can copy/paste:

http://cfhub.com/tutorials/verity/Part21.cfm