try this. it's an in line if, I'm not 100% of the syntax since I don't
have a book in front of me.

<cfgridcolumn name="{(Status.text == 1 ? 'aproved' : 'pending')}" />

On 8/17/05, Tim Starling <[EMAIL PROTECTED]> wrote:
>  
>  
> 
> 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 
> 
>   
> 
>
----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe:
   http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
   http://www.dfwcfug.org/form_MemberRegistration.cfm


Reply via email to