io Critz, I'll be certain to do that. <cfplug> #coldfusion on EFNet is an invaluable source for ColdFusion problem solving. </cfplug>
Thanks :) Eric -----Original Message----- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 05, 2002 10:12 AM To: CF-Talk Subject: Re: Querying multiple Oracle datasources - separate logins - 1 cfquer y oi Eric!! you might wanna swing into #coldfusion on efnet......some bloke was in there this morning talking bout roughly the same thing. -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion"> ------------------------------------ Wednesday, June 5, 2002, 10:03:22 AM, you wrote: CE> Is it possible to join tables in 2 different Oracle datasources (using 2 CE> different logins)? CE> This is a loaded question because I know you can't. You probably need to CE> use a stored procedure or a view. CE> I can do 2 seperate queries, but since both tables are required to narrow CE> down the results, the recordsets have the potential to get pretty big. CE> In a pinch, can anyone suggest any other viable CF4.5 solution? CE> Thanks :) CE> Eric CE> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
