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/cf-talk@houseoffusion.com/
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.
