Hi
I recently started using a program that runs off a oracle database, and my
website runs off SQL server 7.0
how can I run a query so that within one query I can pull data from both
databases?
Thank You
Eli Shechter
~~
Structure your
ot; [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Wednesday, December 13, 2000 1:25 PM
Subject: query between 2 database types
Hi
I recently started using a program that runs off a oracle database, and my
website runs off SQL server 7.0
how can I run a query so that within one q
lk
Subject: query between 2 database types
Hi
I recently started using a program that runs off a oracle database, and my
website runs off SQL server 7.0
how can I run a query so that within one query I can pull data from both
databases?
Thank You
El
not sure if you can. but you can query one DB then populate the results in a
temp table in the other DB
"Eli Shechter" [EMAIL PROTECTED] wrote:
Hi
I recently started using a program that runs off a oracle database, and my
website runs off SQL server 7.0
how can I run a query so that within one
I recently started using a program that runs off a oracle
database, and my website runs off SQL server 7.0
how can I run a query so that within one query I can pull
data from both databases?
You can't really do that from CF. There are ways to get what you want.
One way is to run the two
Gona have to wait for CF 5.0. It has the ability to query a query which will
allow this.
Rick
-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:26 PM
To: CF-Talk
Subject: query between 2 database types
Hi
I recently started using
.
/CFQUERY
P.
-Original Message-
From: Allan Pichler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 2:53 PM
To: CF-Talk
Subject: RE: query between 2 database types
To the best of my knowledge, you can't !
I believe that feature will be available in CF 5, but you would stil n
Gona have to wait for CF 5.0. It has the ability to query a
query which will allow this.
To the best of my knowledge, the ability to query a recordset already
retrieved by CF (which is supposed to be introduced in CF 5) still will not
allow a single query to be run against multiple
TED]
Sent: Wednesday, December 13, 2000 4:06 PM
Subject: RE: query between 2 database types
Gona have to wait for CF 5.0. It has the ability to query a query which
will
allow this.
Rick
-Original Message-
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2
9 matches
Mail list logo