Outputting Query Results with Unknown Column Names

[ctlcal]

I have been using this code to grab the column headers from a select *
statement. (I never know what table will be queried out of 12,000 or so. I want
to loop through the column headers and then the query results in to a web page
table.

<cfoutput>
<cfset colHeaderNames = ArrayToList(recordset1.getColumnList())/>
#colHeaderNames#
</cfoutput>

Is there a similar method or any suggestions for outputting the results of the
query - now that I know the column headers?

[jdeline]

If I understand correctly, you can do something like the code below.


<CFLOOP LIST="colHeaderNames" INDEX="i">
#Evaluate(i)#
</CFLOOP>

[ctlcal]

Thanks for the suggestion, but trying that out it looped through the recordset but just outputted the columnheaders over and over - rather then the field values.

[paross1]

Column names and query results.

Phil

<table>
<tr><cfloop list="#recordset1.ColumnList#" index="col" delimiters=",">
<th><cfoutput>#col#</cfoutput></th>
</cfloop></tr>
<cfoutput query="recordset1">
<tr><cfloop list="#recordset1.ColumnList#" index="col">
<td>#recordset1[col][CurrentRow]#</td></cfloop></tr>
</cfoutput>
</table>

[vkunirs]

Hi

just give ## in side the <cfllop>

<CFLOOP LIST="#colHeaderNames#" INDEX="i">

[ctlcal]

Great suggestion - But then you lose the actual order of columns and get them back alphabetically, which is why I went with the code above.

[ctlcal]

jdeline and vkunirs - This worked great! Thanks for the help!

[paross1]

I was unaware of the getColumnList() method so I have been dong it the "hard
way", which unfortunately, lists the columns alphabetically. I couldn't find
getColumnList() documented in LiveDocs, but nothing surprises me any more.

This other solution is great.

Phil

[ctlcal]

The documentation for "getColumnList" is in the Dreamweaver API Live Docs.

[paross1]

Thanks. Since I don't use Dreamweaver it makes sense that I haven't seen this.

Phil