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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
