Here's something I found in a cf-talk post several month's ago Diana, maybe
it will help ya:
When you create a datasource you are only pointing to a default
database. You can be explicit in your SQL statements to access any database
registered within the SQL Server like so.....
SELECT * FROM <database>.<owner>.<table>
(credit to Andy Ewings for that info, i think :)
Hope that helps!
Brian
----- Original Message -----
From: "Diana Nichols" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 12:51 PM
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
