I've done something like this. I've got a page-based collection and some varying DB-based collections. Depending on the parameters passed, it will add the collections to a list and then use the collection param of cfsearch to display the list. Then you get a nice unified result set with the "custom" being used by each collection to drill down through the data. Keep in mind though that the more collections you add, the slower it gets.
As for the multiple datasource idea from Stephen, I'm not sure. Ryan -----Original Message----- From: Jamie Jackson [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 12:46 PM To: CF-Talk Subject: Re: One search for Spidered Pages, Oracle & Basis DBs Okay, can you give me a hint as to how to populate a collection with more than one datasource? I thought that you had to feed <cfindex> a (single) query object. If you can indeed only feed it a single query object, do you propose I unify two queries from separate datasources? If so, do you know a better way than looping one of the queries and doing query functions to append rows? Okay, say I do get both of these DBs indexed in the same collection, are you saying it's also possible to get my Verity K2 spidered index in there as well!? :-/ Thanks, Jamie On Wed, 11 Jun 2003 18:04:50 +0100, in cf-talk you wrote: >Jamie, > >Why not use one Verity collection which is populated by data from your >multiple datasources. Use one of the custom field to specify which >datasource the record came from. > >That way you use CFSearch to get your a result set with title, summary >and all the good stuff. When the user wants to see the record itself >you use the record id, held in the key field in your collection, and >the datasource identifier from one of the custom fields to decide what >page to display or what database to get the single record from. > >That should be a damn site more speedy than querying and trying to >output from 3 disperate datasources. ;o) > >Stephen > >----- Original Message ----- >From: "Jamie Jackson" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, June 11, 2003 5:52 PM >Subject: Re: One search for Spidered Pages, Oracle & Basis DBs > > >> Nevermind, this should be pretty straightforward. I think I'll just >> do three search routines on the results page, which will return three >> different blocks of results. Also, maybe I'll cfflush to give 'em >> something to look at while it takes forever. ;-) >> >> Thanks, >> Jamie >> >> On Wed, 11 Jun 2003 11:16:29 -0400, in cf-talk you wrote: >> >> >Looking for ideas regarding the creation of a single search >> >interface that (at once) searches pages, Oracle & Basis DBs. >> > >> >Is anybody doing this? >> > >> >Thanks, >> >Jamie >> > >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
