Here is the CFsearch tag I am using. <cfsearch collection="AEwholesale_Products" name="getSearchResults1" type="explicit" criteria="CF_KEY SUBSTRING #trim(form.criteria)#">
Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -----Original Message----- From: Mark W. Breneman [mailto:[EMAIL PROTECTED] Sent: Monday, March 21, 2005 11:33 AM To: CF-Talk Subject: Verity headache with explicit search I am having a problem on one of my sites with the verity search. I need to search a verity collection and retrieve all products that contain any part of the part number. I.e. A search for Q12345 should return part numbers 12345, A12345-B, Q123... Etc The same search criteria is also used in a verity "simple" description search. Both of these CFsearches are then output to the webpage. The problem comes in when someone enters a reserved word in the search box like "book end" "End" is a word verity chokes on when doing an explicit search. I am about to dump the verity search part of the part number and replace it with a SQL partnumber like "%criteria%" query. (Yes, I will have to take steps to make sure SQL injection is not an issue.) Any thoughts? Thanks, Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com <http://www.vividmedia.com/> 608.270.9770 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:199579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54