Thanks Stephen,
I saw the message about doing the multiple locations with access. The issue I'm
having is that we don't use Access. In my case one DSN points to a SQL Server
database and the other DSN points to a FoxPro DSN so I can't create 1 select statement
to query both tables.
So what I would like to do is retrieve the individual DSN data and then join it
together in CF. I know I can do it by manually creating a new empty query then I can
write code to loop through the record sets and "merge" the data together, but it will
kill the performance.
Thanks for your thoughts.
Bill Grover
Supervisor, IS
EU Services, Inc.
649 N Horners Ln
Rockville MD 20850
Phone: 301-424-3300 x396
FAX: 301-424-3300 x1396#
E-Mail: [EMAIL PROTECTED]
WWW: www.euservices.com
----- Original Message ----
Date: Wed, 26 Jul 2000 14:24:04 +0100
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: RE: Can I use 2 datasources in one app?
Message-ID: <001201bff704$c506f2c0$[EMAIL PROTECTED]>
Bill,
>
>
> Not to diverge this topic to much, but something I've been
> wondering how to do, but have always found other ways to do it.
>
Your question was answered by Gene Kraybill who said.....
=======
You CAN actually use multiple sources of data in the very same CFQUERY, but
only one can
be an "official" CF datasource:
<CFQUERY NAME="GrabDataFromMultipleSources" DATASOURCE="AnyValidDSN">
SELECT a.*, b.*
FROM TableInDSN a, "c:\inetpub\wwwroot\database\anyotherdb.mdb".Table b
</CFQUERY>
The syntax to define a table from an undefined datasource is:
"fullfilepath".Table
This method may also be useful for people whose sites are hosted by service
providers --
you can use a datasource even if it hasn't yet been officially set up as a
DSN...
=======
Regards
Stephen
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
