Pete, thanks for your insight. That's the way I was going to go initially, before I started wondering if I could use categories in a db query-based collection and if they will allow me to search photos of specific category only. As I said in answers to Dominic's and Ray's posts, categories do work, but not the way I thought they would... I guess I will g the usual way of doing full-text search with Verity and then filtering the db query resultset, which returns a lot more photo data than a Verity collection holds, with results returned from Verity search. I like Dominic's way of doing the filtering, which seems to outperform the IN/NOT IN () filtering...
Cheers, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Pete Ruckelshaus wrote: > I use Verity often (including in an education-oriented document management > project that I'm working on), but have avoided categories...probably because > of the lack of good documentation on their use. > > What I do is index documents with Verity, and have the [key] be the PK in a > documents table in my database. I will then create any other tables that I > need to further describe or categorize the data and use that to "refine" my > verity search by excluding records as needed with an in/not in statement in > my SQL. That's a very, very boiled down description of the approach I take, > there does tend to be a lot more going on... > > Pete > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302681 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
