Bud wrote: > OK. This is a driver issue. It appears to be a bug in the unicode > access driver. Luckily I have few people using Access. We switched to > the standard driver and now it's acting like it should and like it > always has. > > http://azarflooringgallery.com/bud.cfm > > The column is being returned twice.
It may be acting like it always has, but it is not acting like it should. Imagine the following schema and query: CREATE TABLE thread ( threadID INTEGER PRIMARY KEY, title VARCHAR ); CREATE TABLE message ( messageID INTEGER PRIMARY KEY, threadID REFERENCES thread, title VARCHAR ); SELECT * FROM thread T INNER JOIN message M ON T.threadID = M.threadID; If you output #title#, will you get the title of the thread or the message? The only sensible response is to throw an error because the column name is ambiguous. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:261015 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
