Not at the same time I do not think that is possible
from a pure CF standpoint, perhaps the DB can
do it.. but ill assume it cant..
You can do two seperate queries with one query based on
data from the second.
<CFQUERY NAME="Foo1" DATASOURCE="server1datasource">
SELECT junkID
FROM SomeTable
</CFQUERY>
<CFQUERY NAME="Foo2" DATASOURCE="server2datasource">
SELECT barID
FROM SomeOtherTable
WHERE Foo1.recordcount < 10
</CFQUERY>
Something like that might help? Or you may consider
merging databases or making the data more friendly
for this type of situation.
Just some thoughts, i realize thats not a solution
to your problem so these are just suggestions :-\
Jeremy Allen
[EMAIL PROTECTED]
[Insert cool title here]
-----Original Message-----
From: thanh nguyen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 10, 2000 4:56 PM
To: [EMAIL PROTECTED]
Subject: in one query refers to 2 different odbc sources
I have 2 databases located on the 2 different NT servers, Is there any way i
can write one query that refers to different odbc sources, if yes, how and
the syntax,
thanks
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
