Hi, I've now just started to test the federated storing engine with mysql 5 ... I've a lot of queries and I dont wanna change everything, so lets see if it'll work. I've just installed mysql5 on my machine and try now to create some kind of 'federated table' local. so that my local dbms connects to my other mysql(4)-server and retrieves the data from that remote tables.. hmm.. I hope I'm not wasting my time and get it working :) -- Sebastian Mork [EMAIL PROTECTED] --
On Tue, 7 Feb 2006 15:00:11 +0000 Michael Traher <[EMAIL PROTECTED]> wrote: > could be a candidate for doing in two or three steps and using a query of > queries to combine the data. > > Just a thought > Mike T > > > On 2/7/06, Sebastian Mork <[EMAIL PROTECTED]> wrote: > > > > 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:231586 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
