Uh... the purpose here is to point out the technique of addressing other databases from in the same query. For my part I use "a" and "b" because I don't want to type as much - Obviously they are not necessarily good aliases - although I hasten to add on a very small query they are pretty obvious.
-Mark -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 9:05 AM To: CF-Talk Subject: RE: More than one datasource in <cfquery> NO!!!!!! There are awful table aliases which mean nothing. It is just plain ugly to abbreaviate them like this... at the very least you should qualify the name in some way....table a, b,c and d is just lazy. -----Original Message----- From: Matt Friedman [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 15:10 To: CF-Talk Subject: Re: More than one datasource in <cfquery> A great trick in MS SQL that will solve your issue is to use this format select a.col1,a.col2, b.col1,b.col2 from a, <database_name>..b as b where a.col1 = b.col1 The trick is taht the <database_name> is the name in the SQL server not CF admin. that works fine and you can link as many database as you wish. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206070 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
