Could you just do a UNION within a query of queries? Pete
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:231581 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
