query between 2 database types

2000-12-13 Thread Eli Shechter
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

Re: query between 2 database types

2000-12-13 Thread Greg Wolfinger
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

RE: query between 2 database types

2000-12-13 Thread Allan Pichler
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

Re: [query between 2 database types]

2000-12-13 Thread Alex
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

RE: query between 2 database types

2000-12-13 Thread Dave Watts
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

RE: query between 2 database types

2000-12-13 Thread Rick Lamb
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

RE: query between 2 database types

2000-12-13 Thread Peter Stolz
. /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

RE: query between 2 database types

2000-12-13 Thread Dave Watts
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

Re: query between 2 database types

2000-12-13 Thread Neil H.
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