found something in the mySql-forums.. http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html (The FEDERATED Storage Engine since mySql 5.0.3) -- Sebastian Mork [EMAIL PROTECTED] --
On Mon, 06 Feb 2006 23:49:35 +0100 Sebastian Mork <[EMAIL PROTECTED]> wrote: > 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:231576 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