Occasionally I just need a dump of results from a query columns and values. I have two methods for this.<\/p>\n
The SQL (cfquery name=”myquery”) Occasionally I just need a dump of results from a query columns and values. I have two methods for this. The SQL (cfquery name=”myquery”) Select TOP 1 * from contacts The simple method allows me to output the column … Continue reading
\nSelect TOP 1 * from contacts
\n
\nThe simple method allows me to output the column names and the values in alphabetical order. The evaluate(column) is what displays the values.
\n<cfoutput query=\"myquery\">
\n< cfloop list=\"#myquery.ColumnName#\" index=\"column\">
\n#column#: #Evaluate(column)# <br>
\n<\/cfloop>
\n
\nColumn name list Yields: address, city, contact_id, email, fname, lname, phone, state, zipcode. Which while useful is a bit confusing for output.
\n
\nIf I want my columns output in a particular order I merely replace the \"list=#myquery.ColumnName#\" with a list of the columns I want to display in the order I want to display them. The rest of the code is the same.
\n
\n< cfloop list=\"fname, lname, address, city, state, zipcode, phone\" index=\"column\">
\n
\nI can even suppress data that is blank or meets other criteria within the loop.
\n<cfif #len(EVALUATE(column))# gt 1>#column#:<\/span>
\n <cfif isdate(EVALUATE(column))>
\n #dateformat(EVALUATE(column), \"mm\/dd\/yyyy\")#
\n <cfelse>
\n #EVALUATE(column)#
\n <\/cfif>
\n<\/cfif><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"