> The point is. This isn't expected behavior. The driver isn't > supposed to make up names. I'd alias the column myself if I > wanted that. I've never ever seen this. I see many people > using just * to grab all the fields in all the tables in a > query. When you need all the fields, * is faster than > specifying all the field names. Faster to type and the query > runs faster.
Those people shouldn't be using *. While it's faster to type, the query does not run faster (or significantly slower, either). The problem with * is that it doesn't let a reader know what fields are returned. And, as far as what the driver is supposed to do: I would argue that it shouldn't let you run the query at all. You can't have two columns in the same query object with the same name. If it let you do this before, it shouldn't have. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:260932 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
