Quick output of variables from any query, sans cfdump
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!
<cfset qname = "getD">
<cfset collist = evaluate("#qname#.columnlist")>
<cfloop list="#colList#" index="cc">
<cfset colVal = evaluate("#qname#.#cc#")>
<cfoutput>#cc# : #colval#</cfoutput>
<br />
</cfloop>
The table evaluate is fantastic. Thanks, I've stopped using cfdump. How would you modify the SQL or the CF code to only return columns that had values or weren't NULL?
To narrow down the displayed content as you suggest, I'd look at building an array or query object from the data first, then using that to display the output. ( if you get something working, please post here)