You could be slick and query both databases and then join the two in a new
query with AddQuery and QueryNew()... Or you could make it all a big WDDX
packet (that is always fun)
Neil
----- Original Message -----
From: "Rick Lamb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
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, 2000 12:26 PM
> To: CF-Talk
> 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
>
> Eli Shechter
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
