You dont need CF5 for this...still have not found a good use for the query a
query feature ;-)
This is from a previous message to the list. You can access all SQL Server
databases fully as long as you have at least one odbc connection to the
database server on the web server. I have not fully tested to see if there
could be a security problem, but this works for me.
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 1:03 PM
Subject: RE: SQL Joins with multiple databases
> Use the fully qualified table name:
>
> <database Name>.<owner>.<tablename>
>
> For example:
>
> use hr
> Select * from
> dbo.tblEmployees INNER JOIN
> hrdatabase2.dbo.EmployeeInfo ON
> dbo.tblEmployees.EmployeeID =
> hrdatabase2.dbo.EmployeeInfo.EmployeeID
jon
----- Original Message -----
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 2:41 PM
Subject: RE: JOIN queries from two datasources
> You need CF5's Query a query feature for this
>
> -----Original Message-----
> From: Diana Nichols [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 1:52 PM
> To: CF-Talk
> Subject: JOIN queries from two datasources
>
>
> Sorry if this has been asked before....
>
> Can I join two queries from two different datasources (SQL 2000)?
>
> I need to relate the username/userID from source 1 to userID from source
2.
>
> (If it's too difficult, I'll just copy the username into source 2).
>
> TIA!
>
> D
>
> *************
> Diana Nichols
> Webmistress
> http://www.lavenderthreads.com
> 770.434.7374
>
> "One man's magic is another man's engineering." ---Lazarus Long
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
