Re: can CF do multiple DB connection?

2001-11-04 Thread Paul Hastings
> > coming from the sql server end of things, look at the OPENROWSET & OPENQUERY rowset functions though as other have indicated, you'll need just 1 dsn that has some sort of access to the other dsn you'll be talking to. ~~ Get the mailserver tha

RE: can CF do multiple DB connection?

2001-11-04 Thread Dave Watts
> ok... wat i need is to hav multiple DB connection in a query > statement.. > > for example.. i need to hav a joint query from a oracle > database and a ms sql database.. > > can i actually do this..? > > > . > . > > > ?? or must it be query within a query? > > > . > . > > . > . >

Re: can CF do multiple DB connection? (Access)

2001-11-04 Thread Joseph Thompson
Yes, Access will support that. http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=Last Datasource1=iether of your valid datasources t2 *the path to the second "database" *be sure to add the table name as "SecondDBTable" *SecondDbase is the fi

Re: can CF do multiple DB connection?

2001-11-04 Thread han peng
? . . . . . thanx you ppl.. : ) by the way.. any gd site for CF 5 info to recommend ?? cheers han - Original Message - From: "Darryl Lyons" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 05, 2001 4:10 AM Subject: RE: can CF do mul

RE: can CF do multiple DB connection?

2001-11-04 Thread Darryl Lyons
Don't think so as you've generally got one datasource per access database.. I'm not really an Access-using person.. -Original Message- From: W Luke [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 10:05 AM To: CF-Talk Subject: Re: can CF do multiple DB connectio

Re: can CF do multiple DB connection?

2001-11-04 Thread W Luke
Can Access support cross-database joins? Will - Original Message - From: "Darryl Lyons" <[EMAIL PROTECTED]> Newsgroups: gradwell.lists.cftalk Sent: Sunday, November 04, 2001 8:23 PM Subject: RE: can CF do multiple DB connection? > If your using db like SQL Serv

RE: can CF do multiple DB connection?

2001-11-04 Thread Darryl Lyons
: tom muck [mailto:[EMAIL PROTECTED]] Sent: Monday, 5 November 2001 2:55 AM To: CF-Talk Subject: Re: can CF do multiple DB connection? It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every

Re: can CF do multiple DB connection?

2001-11-04 Thread tom muck
It sounds like you are confused by why the application.cfm has the DSN connection defined -- the main reason is so that you don't have to define it on every page and can change it in one place if you need to change it for any reason. If you want to use more than one, simply define more than one v