I believe this is one of those bugs that you create while trying to make thing
better then actualy possible!
Why can't we access the query objects in a normal recordset way? The query
object recognises row numbers.. witch is normal, but not column numbers. In
order to user the query object you always have to specify the column name.
Now try and merge several tables with identical names in your query! CF will
return a query with repeated column names and, even worst, it will only retain
the value on the first of the repeated fields. The only way to contour this
bug, is to specify in the query, field by field (and with AS statement),
diferent field names.
Just imagine you're merging 4 tables with 20 fields each... you'll HAVE to
type a SQL statement with 80 fields, all with a AS SOMETHING ELSE statement!
PHP is Free and doesn't do this! ASP is crappy and doesn't do this! Why in
hell coldfusion, the best web language ever built, expensive as hell,
does?!?!?! Either there is another way (i've searched the entire documentation)
or it's a bug as big as a house!