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