True - but I had assumed this was only part of his query. If this truly WAS the only part, than a pure SQL search makes a lot more sense. My bad. If he is using this with other items, then I think it would make sense in Verity.
On 6/20/07, Dave Watts <[EMAIL PROTECTED]> 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. > > -- =========================================================================== Raymond Camden, Camden Media Email : [EMAIL PROTECTED] Blog : ray.camdenfamily.com AOL IM : cfjedimaster ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:281629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
