Re: data from two datasources: got it with mysql

2006-02-07 Thread Sebastian Mork
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-

Re: data from two datasources

2006-02-07 Thread Sebastian Mork
> > > 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] > > >

Re: data from two datasources

2006-02-07 Thread Michael Traher
? > > -- > > 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)

Re: data from two datasources

2006-02-07 Thread Pete Ruckelshaus
DataBaseName.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 > > [EM

Re: data from two datasources

2006-02-07 Thread 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)??? &g

Re: data from two datasources

2006-02-06 Thread Sebastian Mork
gt; 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/artic

Re: data from two datasources

2006-02-06 Thread Sebastian Mork
gt; 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/artic

data from two datasources

2006-02-06 Thread Sebastian Mork
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