ok, my mistake..
so this would work, if both databases would be on the same server.
So I could at first use the dataSource-name of my odbc-conn in the cfquery tag
and get access to another database directly by
its database name (dbname.tablename.fieldname)
e.g. this would work if both were local:
cfquery name="test" datasource="myDataSourceName"
select
tbl_products.fld_pid as pid
,myLocalMysqlDataBaseName.tbl_pdata.fld_teaser as teaser
from
tbl_products
left join
myLocalMysqlDataBaseName.tbl_pdata on
myLocalMysqlDataBaseName.tbl_pdata.fld_pid=tbl_products.fld_pid
where 1=1
/cfquery
But is it possible to get access to an additional database through its
datasource-name (because its on a remote server)?
--
Sebastian Mork
[EMAIL PROTECTED]
--
On Mon, 06 Feb 2006 22:23:55 +0100
Sebastian Mork <[EMAIL PROTECTED]> wrote:
> Hi,
>
> is it in general possible (using mysql 4.1.10) in any way to get data
> from two datasources (combined in one query-tag)???
>
> Asking google showed me some infos about ms sql (combining data from several
> sources.. http://www.databasejournal.com/features/mssql/article.php/3578546)
>
> Hmm... well.. I thought of just doing something simple like this..
> select
> #strApp.localDsn#.tbl_products.fld_pid as pid
> from
> #strApp.localDsn#.tbl_products
> left join
> #strApp.RemoteDsn#.tbl_pdata on
> #strApp.RemoteDsn#.tbl_pdata.fld_pid=#strApp.localDsn#.tbl_products.pid
> where 1=1
>
> But at first it (of course :) doesnt work, 2nd problem would be the
> dsnUser+Pass-args that can be set only
> once in the query-tag. (didn't look at queryparams yet)
>
> Anyway.. is that generally possibly? Is it possible with mysql?
>
> --
> Sebastian Mork <[EMAIL PROTECTED]>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231521
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
