From: "Kris Jones" > In general, it is up to the developer to alias the columns so that > they can be referenced appropriately in such a scenario. I also am not > a fan of the * in queries. And, I wonder, in the example you have > given, why this is an issue, since the values for the columns will be > exactly the same?
It's not a matter of the values, but the column names. Moving an application from a CF5 server using Microsoft ODBC drivers to a CF8 server, I found that this 'Access with Unicode' driver behaves differently than the ODBC driver that had been used previously, and also differently from the other Access driver included with CF8. The application expects to have a column named 'userid' returned in the query, but it doesn't exist. I'd never run into the issue before trying to use this particular Access driver, so wasn't aware that doing this could cause confusion. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
