Thanks for the response
I am using MS access database
I tried using both Query of Queries and Cross database query and both works
well however performance wise Cross database query is better
Thanks again for the help
~|
Logwar
Thanks for the response
I am using MS access database. I tried using following 2 methods
1)
Select d1.* From #AppPath#\DB1.mdb.TableName
d1,#AppPath#\DB2.mdb.TableName d2 Where d1.id=d2.id
2)
Select * from Table1
Select * from Table2
Select sql.*
>From s
Thanks for the response
I am using MS access database. I tried using following 2 methods
1)
Select d1.* From #AppPath#\DB1.mdb.TableName
d1,#AppPath#\DB2.mdb.TableName d2 Where d1.id=d2.id
2)
Select * from Table1
Select * from Table2
Select sql.*
>From s
:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 3:45 PM
To: CF-Talk
Subject: Re: More than one datasource in
It would be great to hear if any of this helps 'simmyana' :-)
On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to use more than one dataso
Dave Watts wrote:
>> Does anybody know if queries against MS SQL Server linked
>> servers run in one transaction?
>
> Yes, I think they can, using MS DTC:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx
I don't think that you can access XA functionality from CF
witho
It would be great to hear if any of this helps 'simmyana' :-)
On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote:
> Hi,
>
> How to use more than one datasource in tag?
>
> Thanks
>
>
~|
Fi
Ah yes. We have Benefactor here which runs over Unidata. Its
unfortunate that you must use UniQuery to do all the interactions with
the DB (on our version). One of the newer versions of Unidata is
supposed to support ODBC with an add-on package. Unfortunately, we
don't have it. :(
--Jeff
>That depends on your definition of a database
IBM's Unidata renamed "database" to "account". Unidata's databases, so
to speak, are directory structures. Some files in a base directory,
others are in sub directories.
If you want to see a whacked non-rdbms solution, you should read a
whitepaper,
: More than one datasource in
> Nice. So it's only possible with MySQL and MS SQL Server
> data sources? I
> don't know what DB Simmyana is using but the one I
> mentioned was SQL server.
~|
Logware (www.
> Does anybody know if queries against MS SQL Server linked
> servers run in one transaction?
Yes, I think they can, using MS DTC:
http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the
> Nice. So it's only possible with MySQL and MS SQL Server
> data sources? I
> don't know what DB Simmyana is using but the one I
> mentioned was SQL server.
Iirc, with MS Access if you place multiple db's in the same directory,
you can reference them in queries to any of them the way that you can
Ewok wrote:
> Nice. So it's only possible with MySQL and MS SQL Server data sources?
That depends on your definition of a database :-) If you look
carefully at what MySQL calls a database you will see that it is
actually not a database but a schema and all that is implemented
is cross-schema qu
> NO!! There are awful table aliases which mean nothing. It is just
> plain ugly to abbreaviate them like this... at the very least you should
> qualify the name in some waytable a, b,c and d is just lazy.
Woah, lean back, take a deep breathe then pop a pill. It's too early in the
week
-Talk
Subject: RE: More than one datasource in
Nice. So it's only possible with MySQL and MS SQL Server data sources? I
dont know what DB Simmyana is using but the one I mentioned was SQL server.
-Original Message-
From: Mark A Kruger [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09,
y they are pretty
obvious.
-Mark
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 9:05 AM
To: CF-Talk
Subject: RE: More than one datasource in
NO!! There are awful table aliases which mean nothing. It is just plain
ugly to a
tson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 8:25 AM
To: CF-Talk
Subject: RE: More than one datasource in
Yep basically the format is database.owner.table.column
So you could do SELLECT * FROM EmployeeDirectory.dbo.Employee
-Original Message-
From: Adam Haskell
2005 15:10
To: CF-Talk
Subject: Re: More than one datasource in
A great trick in MS SQL that will solve your issue is to use this format
select a.col1,a.col2,
b.col1,b.col2
froma,
..b as b
where a.col1 = b.col1
The trick is taht the is the name in the SQL server not CF
A great trick in MS SQL that will solve your issue is to use this format
select a.col1,a.col2,
b.col1,b.col2
froma,
..b as b
where a.col1 = b.col1
The trick is taht the is the name in the SQL server not CF
admin.
that works fine and you can link as many database as you
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 8:25 AM
To: CF-Talk
Subject: RE: More than one datasource in
Yep basically the format is database.owner.table.column
So you could do SELLECT * FROM EmployeeDirectory.dbo.Employee
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECT
Yep basically the format is database.owner.table.column
So you could do SELLECT * FROM EmployeeDirectory.dbo.Employee
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: 09 May 2005 14:27
To: CF-Talk
Subject: Re: More than one datasource in
If you use MS SQL you
mean 'project'. I thought it was my only (worthwhile)
> option
>
> -Original Message-
> From: Robertson-Ravo, Neil (RX)
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 09, 2005 8:05 AM
> To: CF-Talk
> Subject: RE: More than one datasource in
>
> Erm, well you can o
in my latest
nightmare... oh I mean 'project'. I thought it was my only (worthwhile)
option
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 8:05 AM
To: CF-Talk
Subject: RE: More than one datasource in
Erm, well you can only
Which database?
- Matt Small
-Original Message-
From: simmyana a [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 2:05 AM
To: CF-Talk
Subject: More than one datasource in
Hi,
How to use more than one datasource in tag?
Thanks
Erm, well you can only use one DSN in a single CFQUERY but you should be
able to use a Cross Database Query allowing you to search across two
databases.
-Original Message-
From: Ewok [mailto:[EMAIL PROTECTED]
Sent: 09 May 2005 13:06
To: CF-Talk
Subject: RE: More than one datasource in
ana a [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 2:05 AM
To: CF-Talk
Subject: More than one datasource in
Hi,
How to use more than one datasource in tag?
Thanks
~|
Logware (www.logware.us): a new and convenient w
At 12:22 AM 5/9/05, Thanks wrote:
>How to use more than one datasource in tag?
I think J is technically right about CFQUERY but there have to be other
ways to skin the cat, such as by using two separate queries on different
datasources and then combining their outputs with a query-of-qu
#x27;t. :/
>
> Perhaps a more in-depth description of the need would help us resolve the
> issue?
>
> Laterz,
> J
>
> On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote:
> >
> > Hi,
> >
> > How to use more than one datasource in tag?
> &
Simmyana,
Well... basically... you can't. :/
Perhaps a more in-depth description of the need would help us resolve the
issue?
Laterz,
J
On 5/9/05, simmyana a <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> How to use more than one datasour
Hi,
How to use more than one datasource in tag?
Thanks
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with
29 matches
Mail list logo