parameterizing columns and column titles

[ro1016]

Hi everybody,

I’m doing some reports in coldfusion with sql server backend. I’m trying to create a template for displaying the reports. What I want to do is that when I write the queries in sql server count the number of fields in the select statement and use that for the number of columns and get the alias(the As statement) to use as the name of the column in coldfusion. Counting the number of fields and columns shouldn't be a big problem but has anybody ever done or has any idea of how to get the alias for column title in coldfusion?

 

[ecobb]

You can use query_name.columnList to get list of columns returned from your query, it should use whatever aliases you assign in your query.

Example:

<cfquery name="GetName">
Select [first name] AS FirstName, [Last] AS LastName
From WhateverTable
</cfquery>

<cfoutput>#GetName.ColumnList#</cfoutput>

The above should return a list with the values "FirstName,LastName".


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[ro1016]

Thank you ECAR, I'm gonna try this.

"Beyond ideas of right and wrong, there is a field. I'll meet you there." Rumi