To the best of my knowledge, you can't !
I believe that feature will be available in CF 5, but you would stil need to
run 2 queries. The new feature in CF 5 allows you to run queries on existing
recordsets! As you probably know you can only specify one DATASOURCE pr.
query, so accessing 2 from one query is not possible.
Ask "mice" (<-- irc handle) i believe he's working for the same company as
you. (thesquare.com)
Allan Pichler
Machine Dreams Inc.
-----Original Message-----
From: Eli Shechter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 10:26 AM
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