Rename Query Column Name

[DickBobUK]

I know I can rename the column in the db by using AS, but I don't have those
priv's and I've got some really ugly column names which I'd like to rename to
something nicer when I CFQUERY the data into a record set. Thoughts anyone?

[TA-Selene]

If you are writing the query using CFQUERY then you can use AS to create an alias for the column names.

[DickBobUK]

Sorry, I shoud have been more clear.

I'm calling a stored procedure so I can't rename the columns using AS in CFQUERY.

[kyle969]

Use query of query.

<cfstoredproc result="qResult" ... />

<cfquery dbType="query">
SELECT ReallyLongAndUglyColumnNameLikeThis as newCol1
FROM qResult
</cfquery>

[kyle969]

If the column names are much longer than the data values and it is a large
resultset you should recomend changing them to the DBA. If the record is 20
bytes and the column names are 256 bytes, each record is sent over the network
as 256 bytes, the execution time would be greatly improved if the column names
were smaller.

[DickBobUK]

Thanks for your comments Kyle. I was trying to avoid the processing/memory of
doing a query of query, but I guess it's the only way. Good point you raised
about the overhead of long column names. I hadn't thought of that before!