Peter, It's certainly possible. The key is to use multiple CFINDEX tags to build the collection. When you execute a search, you then need to do some sort of parsing on the result query to determine how to build the link to the appropriate resource.
With the use of the custom fields available in Verity, we've successfully integrated half-a-dozen different database tables and 2-3 file system trees into the one collection. For example, we might have a website with a calendar system, a library of FAQs and a document library. Depending on the contents of the search query, a line in the list of search hits might link to a calendar event, a particular FAQ, a document or just a plain old web page. Jaime Metcher > -----Original Message----- > From: Peter Shaw [mailto:[EMAIL PROTECTED] > Sent: Monday, 26 November 2007 9:18 PM > To: CF-Talk > Subject: Combine Documents and Databse Records in a Verity Index > > > We're exploring Verity to use on a new project. Our user profiles > are made up of several database fields and an optional uploaded > document (word / pdf). Is it possible to combine both file and > database data in a Verity index so that we can search both with a > single CF_Search? Ideally we only want to get one ranked result > set back to work with. > > Our work around would be to create two collections, one for > files, one for database records and merge the two results sets - > but this seems an inferior path. > > Peter > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293798 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
