Here's a quick and dirty way to show the column names and corresponding values from any query on any cfm page, without the sometimes-awkward (and often layout-breaking) cfdump table.

Rather than spanning out right to left, this just creates a simple vertical plain-text list of column names and values.

Simply drop this in your page, change the query name (qname)and of course feel free to modify at will... comments welcome!

view plain print about
1<cfset qname = "getD">
2<cfset collist = evaluate("#qname#.columnlist")>
3<cfloop list="#colList#" index="cc">
4<cfset colVal = evaluate("#qname#.#cc#")>
5<cfoutput>#cc# : #colval#</cfoutput>
6<br />
7</cfloop>