cfgridcolumn

[Tim Starling]

Hi everyone,   I am working on a page that will show people the transactions that they have made in their account.  I want to use cfgrid in a flash cfform and the cfgridcolumn tags to display the data.  I can get the data from the database and display it in the grid fine.  However, in a couple of the columns I use 1’s and 2’s to instead of “Approved” or “Pending”.  Does anyone know of a way to take the 1 or 2 that is returned and do something like a cfswitch cfcase to display “Approved” or “pending” instead of “1” or “2”?    My current code is below:                                       <cfgrid query="myQuery" rowheaders="no" name="AccountBalance">                                                 <cfgridcolumn name="PaymentDate" header="Payment Date" mask="MMMM DD, YYYY" />                                                 <cfgridcolumn name="Amount" header="Amount" type="currency" >                                                 <cfgridcolumn name="Type" header="Payment Type" />                                                 <cfgridcolumn name="PayMethod" header="Payment Method" />                                                 <cfgridcolumn name="PostStatus" header="Status" />                                     </cfgrid>     The column that I would like to switch is PostStatus.  I’ve looked all afternoon and haven’t been able to find anything.  Any help would be appreciated.   Thanks, Tim