Select c.* from mytable C is aliasing 'mytable' as 'c' If you run your same query in the Access query analyzer you are going to get the exact same results. It is NOT a 'bug' in the Unicode driver. A bug would be returning results that it shouldnt. Since Access itself returns those EXACT same results... the driver does what it should.
..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 6:27 AM To: CF-Talk Subject: RE: Queries adding table Alias to column name Bobby Hartsfield wrote: > > 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. I didn't tell it to alias the Column. Select Column AS MyAlias is telling it to alias the COLUMN NAME. I DID NOT do that. Select T.Column FROM Table T is NOT telling it to use an alias. It's aliasing the TABLE NAME so I don't have to type Tables.Column. >>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. You're 100% wrong Bobby. It's only the buggy unicode driver that returns these totally unexpected results. I'll certainly alter my code in the future to take this bug into account, but it's still a bug. -- 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:261840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
