cfquery datasource for multiple databases 1

[gatetec]

I have a cf query that pulls out from two databases (MS SQL 2000).

select empid, lname, fname, jobtitle, bla....
from EMPHRDB..empdemo
where jobtitle not like '%Regular%' and
bla....
empid NOT IN (select empidsev
from EMPSEVDB.empsevdemo
where hirestatus not like '%term%')
order by empid, bla....

As you can see, there are two separate databases, EMPHRDB and EMPSEVDB.

In this case, what/how do you put for 'datasource' <cfquery name ="getempdemo" datasource ="????????">

thx much

 

[philhege]

You can use a single datasource so long as the login has rights to both databases.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
Pity the insomniac dyslexic agnostic. He stays up all night, wondering if there really is a dog.

 

[gatetec]

that is great!

thx much