>Kristin Collins wrote:
>
>Does the user that you are connecting to the request.dsn with have
>access to the compdb database? Are the two databases on the same server
>or are the servers linked?
>
>You said "datasources" in your message, and you can't query across CF
>datasources (except by com
Kristin Collins wrote:
> I need to write an sql statement within a cfquery tag that pulls from two
> seperate datasources.
>
> But it's coming back with "Invalid object name "
>
> Below is the what I have written:
>
>
> SELECT townid as tid, town as cityname from towns
> where siteID = 1
> uni
I need to write an sql statement within a cfquery tag that pulls from two
seperate datasources.
But it's coming back with "Invalid object name "
Below is the what I have written:
SELECT townid as tid, town as cityname from towns
where siteID = 1
union
select distinct city as cityname
from comp
3 matches
Mail list logo