Re: Join up datasources

2002-03-26 Thread Sharon DiOrio

As far as I know, this isn't possible.  What is possible is doing two
seperate queries and making your own dataset with either QueryNew() or
building a structure.  Can you give us some more information?

Sharon
- Original Message -
From: "Robert Everland" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 26, 2002 11:15 AM
Subject: Join up datasources


> Is it possible to have a query where you don't specify a datasource
> and then inside of the query join up more than one datasource. Something
> like this
>
> 
> Select DSN.Database.Table.Row,
> differentdsn.database.table.row
> From dsn.database.table,
> differentdsn.database.table
>
> 
>
> Robert Everland III
> Dixon Ticonderoga
> Web Developer Extraordinaire
> 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Join up datasources

2002-03-26 Thread Robert Everland

Is it possible to have a query where you don't specify a datasource
and then inside of the query join up more than one datasource. Something
like this


Select DSN.Database.Table.Row,
differentdsn.database.table.row
From dsn.database.table,
differentdsn.database.table



Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists