> I don't care what happens in Query Analyzer. Well, there is where your problem starts. The driver simply lets CF communicate with the access database. What the analyzer returns is the exact same thing that the driver is giving you.
The next time you need help, just tell us what you want to hear and we'll see what we can do. ..:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bud [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 29, 2006 7:45 AM To: CF-Talk Subject: RE: Queries adding table Alias to column name >Select c.* from mytable C is aliasing 'mytable' as 'c' Yes, I know. That's not the problem. The problem is that the COLUMN is being returned as c.columnname. This should NOT happen. >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. I don't care what happens in Query Analyzer. Microsoft is know to do things not quite "by the book". Why do all other drivers return the actual column name? If it's NOT a bug, then is there is a bug in ALL the other drivers? Here are samples on SQL Server and MySQL. http://www.cf-ezcart.com/bud.cfm http://www.cf-ezcart.com/mysql/bud.cfm Can you show me an example of one (other than the buggy unicode driver) that returns the table name as part of the column name? This is the first time I've seen it since I started coding in 1997. -- 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:261989 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
