Rick, "blue and ear" should return the results you want. In fact, for simple user searches, using listChangeDelims(searchTerms," and ", " ") will force an "and" between each search term.
This will cause an error if the user puts in their own "and" or "or", so only do that if there's not already an "and" or "or" in the searchTerms already... --Daryl ----- Original Message ----- From: "cfhelp" <[EMAIL PROTECTED]> To: "KCFusion" <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 8:56 AM Subject: [KCFusion] Verity I have created a Verity (SQL Data) that I index once a day separate from the search. Then on the website I run the CFSEARCH tag against it but it doesn't search out all keywords. If I search for "Blue" I get back anything with Blue in it. If I search for "Blue Ear" I get back anything with "Blue Ear" but not "My ear is blue" I thought Verity was supposed to return results in that matter by relevance? This is the search tag on the search page. <cfsearch collection="BE_SearchAll" criteria="#criteria#" name="SearchResults" type="EXPLICIT"> I also tried "Simple". <!--- The file that runs daily is: ---> <cfquery datasource="BlueNew" name="QryGetNewPost"> SELECT ListMessages.MessageGUID, ListMessages.EntryDate, ListMessages.Subject, ListMessages.Body, ListMessages.MemberID FROM ListMessages WHERE (Blocked = 0 AND Hold = 0) </cfquery> <cfindex query="QryGetNewPost" action="UPDATE" key="MessageGUID" collection="BE_SearchAll" title="Subject" type="CUSTOM" body="Subject,Body" custom1="EntryDate" custom2="MemberID"> Rick ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
