how to insert ","s (commas) into cfsearch criteria? 1

[gtbikerider]

I'm using verity to search. The user naturally enters an unknown number of words which are used as the criteria to search on. The words need to be separated by commas as I understand it [and there may well be a better way to achieve this?].

code is:
<cfsearch name="results" collection="collection" type="simple" criteria="#criteria#">

How do ensure that if the user enters...
"dogs fish cats"
I use "dogs, fish, cats," as the criteria?


--
John

http://www.redleaf.co.uk

http://www.fusedocs.com

 

[TruthInSatire]

you don't want "dog, fish, cat" either. you want "dog,fish,cat", no spaces.

anyway.

<cfset criteria = "dog, fish cat">
<!--- remove all ", " (comma then space) that will prevent "dog,,fish,cat" after it is all done --->
<cfset criteria = replace(criteria, ", ", ",","ALL")>
<!--- remove all " " (spaces with no comma's before it) --->
<cfset criteria = replace(criteria, " ", ",","ALL")>


Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)