> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281609 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
