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