Hi Dave, Thank you for your response. I would normally agree with you however in my specific case I feel I need to use verity. I neglected to mention all the other search criteria that is involved in order to simplify the question and not cause confusion. Doing a simple price range search in SQL would be the easiest way given the information I posted. Thank you again for your response.
Dave Watts wrote: >> Well I have a problem with a verity search I am doing. The >> collection is based off a query of product data. My >> collection has cf_custom2 data in it which represents the >> products price. When I search the collection with: >> >> criteria="CF_CUSTOM2 <= 19.99" >> >> I will get results with CF_Custom2 with values all over the >> place, like 108.95. The interesting thing is I will not get >> any price that do not start with a 1. I have tested with >> other numbers in the criteria and they all behave the same. >> >> Am I missing something on how verity execute this search. It >> seems to work great when I use the = operator but returns >> unwanted results when I use the other numeric operators. >> >> To give this some purpose, what I am trying to do is a price >> range search of my collection. >> > > While Ray's solution would work, the real problem is that you're using the > wrong tool for the job. You have product prices in a database, and SQL is > the ideal way to answer this question, faster and more efficiently than > full-text search. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > This email has been processed by SmoothZap - www.smoothwall.net > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
