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
