Hi Ray, I appreciate your dropping in on the thread - love your blog!
My doubt about support of categories for a db query-based collection was due to the lack of info on the subject. I did since find one direct reference on the subject in the CF8 Developers Guide. However, the categories in a collection do not work as I thought they would - they do not 'sort' the items in a collection by category, instead selected categories are just assigned to all items in a collection. So to be able to allow a user to search photos in selected categories only, i will have to create a separate collection for each category and then search multiple collections... Did I get that right? At least my tests have shown that that's how it works... Another question I thought you may be able to clarify for me: the Verity limit of 125,000 indexed documents on CF8 Standard - is that a limit per collection or for all collections combined? If it is a combined limit then I can easily run over it having multiple collections for each photo facet, category and keyword... Thanks, Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Raymond Camden wrote: > On Tue, Apr 1, 2008 at 1:36 AM, Azadi Saryev <[EMAIL PROTECTED]> wrote: > >> 1) does a database query-based Verity collection support Categories? or >> is it supported only for document/directory based collections? >> > > Yes. Remember, to Verity, a collection is a collection. It doesn't > matter what 'seeds' it, whether you seed it with physical files, > database records, or peanut butter and chocolate. > > > >> 2) i am creating a collection and search interface for a multi-faceted >> photo database, where each photo has multiple facets, categories and >> keywords assigned to it. >> while i can create a collection that combines all the >> facets/categories/keywords in the collection's body (together with title >> and description), i think it will work better with facets and categories >> stored as collection/photo categories... >> > > Agreed. > > >> any thoughts/suggestions? >> > > Have you read the CF/Verity docs, specifically those covering how to > use categories? It is covered and you should begin there. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302680 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

