> In my case, using M.*,C.* should return the Main_Category_ID from the M. table since it's specified first.
Why? You are asking for both and you are getting both the only way any database engine knows how to give them... with the alias you TOLD it to use for the table names. > Go back through millions of lines of code and > hundreds of applications because of a bug in > CF or the driver? Or change the query to return what you need? > Why does everyone act like this is the norm? Because we are all out to get you Bud. It's a CF-Talk conspiracy. Bad things could happen to me just for talking about it but I thought you had a right to know. I've said too much. I should go now; they're watching If your 1 and only question is STILL where is the bug then I'd say in your code. Not CF or a DB driver. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED] Sent: Saturday, November 18, 2006 5:41 AM To: CF-Talk Subject: Re: Queries adding table Alias to column name > > >I guess it's a CF issue, since you're going to see it no matter what >database you use. You're selecting two columns called Main_Category_ID >and CF doesn't know which one to use. So it uses both, prepending the >alias. Why does everyone act like this is the norm? CF has never done this before. It just returns both fields in the order they're called. I've written thousands of queries like this. This is a brand new occurrence. >You have three options: > >1. Manually enter all the field names, as you described. > >2. Change the column name in one of your tables. > >3. Use the variables C.Main_Category_ID and M.Main_Category_ID (e.g. ><cfoutput>#C.Main_Category_ID#</cfoutput>) Go back through millions of lines of code and hundreds of applications because of a bug in CF or the driver? -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ Toll Free: 877.207.6397 - Local & Int'l Phone/Fax: 386.789.0968 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261025 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
