That's a good idea, as it is on the same server, and will be in general. But then this corners us into MSSQL (which I am sure we will use)
But joining queries by Query of Query is the best bet otherwise from my reading, right? -----Original Message----- From: Jann E. VanOver [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 13, 2005 3:33 PM To: CF-Talk Subject: Re: Querying across two datasources example? Are these two datasources on the same server? Which DBMS? Using SQL Server, I use a dot-dot notation to refer to other databases on the same server: STUFF is the datasource known to ColdFusion and it has a table named "stuff". OtherStuff is a database on the same server that has a table named "moreStuff" ... <cfquery datasource="stuff" name="stuff"> SELECT s.field1, t.field2, t.field3 FROM stuff s INNER JOIN OtherStuff..moreStuff t on s.field = t.field </cfquery> Eric Hoffman wrote: >Is there such a beast that is pretty concise? > >I have a app that needs to query some data from an external datasource now. >Just looking at theory: > >So, I query our data. > >Then query their data. > >Then query what? A query of queries or something? > >Or shortcuts? > >Thanks! > >Eric > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218127 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
