Participating Frequently

Answered

Outputting Query Results with Unknown Column Names

9 replies
1094 views
Translate

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?

Database access

This topic is closed to new replies. Start a new post to keep the conversation going.

Correct answer

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

C

ctlcalAuthor

Participating Frequently

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

Translate

P

paross1

Participating Frequently

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

Phil

Translate

C

ctlcalAuthor

Participating Frequently

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

Translate

P

paross1

Participating Frequently

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

Translate

A

Anonymous

Correct answer

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

Translate

C

ctlcalAuthor

Participating Frequently

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.

Translate

P

paross1

Participating Frequently

Column names and query results in a table. (Good luck with changing the column order

)

Phil

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.