> > Quick question.
> > Can I use 2 different datasources in a CF page?
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...
Gene Kraybill
LPW & Associates
Mansfield, PA
------------------------------------------------------------------------------
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.
