Combine Databases

[rokit1313]

How do you combine databases that use two different datasouces?

[Dan Bracuk]

Valuelist
query of query

Combine them how?

[mxstu]

rokit1313,

The answer depends on what type of operation you need to perform and what type of database are you using. Can you provide more information?

[BKBK]

Do you mean "How do you combine 2 or databases into one datasource?".
A database is real, but a datasource is more or less abstract. Roughly
speaking,
it's the difference between you and "Rokit1313". It is the Coldfusion
Administrator's
job to map databases to datasource names.

[rokit1313]

sorry it was pretty vague. I mean. I have a table called people in datasoure1
and a table called phone in datasource2. I have a key in the "people" table
that i want to use to get the phone number from the "phone" database.
Typically if they where in the same data source i would do something like this:

<CFQUERY DATASOURCE="SameDatasource">
Select p.PhoneNumber
From phone p, people l
WHERE l.id = p.id
</CFQUERY>

But since they are in different datasources i don't know what to do. I hope
that makes a little more sense. thanks for the help.

[Dan Bracuk]

q1(datasource1)
select id
from etc

select phonenumber, etc
from etc
where id in #Valuelist(q1.id)#

If id is a char field, use quotedvaluelist

Originally posted by: rokit1313
sorry it was pretty vague. I mean. I have a table called people in
datasoure1 and a table called phone in datasource2. I have a key in the
"people" table that i want to use to get the phone number from the "phone"
database. Typically if they where in the same data source i would do something
like this:

<CFQUERY DATASOURCE="SameDatasource">
Select p.PhoneNumber
From phone p, people l
WHERE l.id = p.id
</CFQUERY>

But since they are in different datasources i don't know what to do. I hope
that makes a little more sense. thanks for the help.