> > >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:261011 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
