James Smith wrote: >I get no results! I have tried using both names (music,dvd,games) and ID's >(5,3,6) in the category field and neither work. The collection is populated >from an SQL query. > >Does anyone have ANY idea why this might not be working as you would expect?
I can't answer why it doesn't work, but we recently started using category stuff in our CMS, and had similar problems. Dumping the results of the cfsearch clearly showed that the index entries contained the information, but trying to search BY category didn't work. Using cfcollection to view the set of categories for the collection also showed very inconsistent results: sometimes the category list would be complete, sometimes it looked like it just had the most recent entry indexed. The good news (maybe) is that you can explicitly query that field of the index, which is named "cf_enum_category". So you could do something like: cf_enum_category <contains> `5` (It would also be worth checking that the collection in question really does have category support turned on, too.) Sixten ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
