Readability
The following example show how you can toggle which database query columns are displayed by the <CFDUMP> tag in ColdFusion by specifying the show or hide attribute.
<cfquery name="getArtists" datasource="cfartgallery" maxRows="5"> SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME, A.ADDRESS, A.CITY, A.STATE FROM ARTISTS A </cfquery> <cfoutput> <p>query columnList:<br/> #getArtists.columnList#</p> </cfoutput> <cfdump var="#getArtists#" metaInfo="false" format="text" show="FIRSTNAME, LASTNAME" /> |
And the output of the <CFDUMP> tag is as follows:
query columnList:
ADDRESS,ARTISTID,CITY,FIRSTNAME,LASTNAME,STATEquery [Filtered - 2 of 6 columns shown]
[Record # 1]
FIRSTNAME: Aiden
LASTNAME: Donolan[Record # 2]
FIRSTNAME: Austin
LASTNAME: Weber[Record # 3]
FIRSTNAME: Elicia
LASTNAME: Kim[Record # 4]
FIRSTNAME: Jeff
LASTNAME: Baclawski[Record # 5]
FIRSTNAME: Lori
LASTNAME: Johnson
The previous example specifies which columns should be shown by setting the show attribute to “FIRSTNAME, LASTNAME”. If you wanted to prevent certain columns from being displayed by the <CFDUMP> tag, you could set the hide attribute, as seen in the following example:
<cfquery name="getArtists" datasource="cfartgallery" maxRows="5"> SELECT A.ARTISTID, A.FIRSTNAME, A.LASTNAME, A.ADDRESS, A.CITY, A.STATE FROM ARTISTS A </cfquery> <cfoutput> <p>query columnList:<br/> #getArtists.columnList#</p> </cfoutput> <cfdump var="#getArtists#" metaInfo="false" format="text" hide="ARTISTID, ADDRESS, CITY, STATE" /> |
And the output of the <CFDUMP> tag is as follows:
query columnList:
ADDRESS,ARTISTID,CITY,FIRSTNAME,LASTNAME,STATEquery [Filtered - 4 of 6 columns hidden]
[Record # 1]
FIRSTNAME: Aiden
LASTNAME: Donolan[Record # 2]
FIRSTNAME: Austin
LASTNAME: Weber[Record # 3]
FIRSTNAME: Elicia
LASTNAME: Kim[Record # 4]
FIRSTNAME: Jeff
LASTNAME: Baclawski[Record # 5]
FIRSTNAME: Lori
LASTNAME: Johnson
Share
Hosting
Examples hosted by
