On the original code I get this error:
You must specify the name of a column in the query "qFundsAvailable" for the
{(Status.text == 1 ? 'aproved' : 'pending')} attribute of the CFGRIDCOLUMN
tag.
SO, I changed the Status.text to PostStatus.text to match the column in the
database and I get the same error.
You must specify the name of a column in the query "qFundsAvailable" for the
{(PostStatus.text == 1 ? 'aproved' : 'pending')} attribute of the
CFGRIDCOLUMN tag.
Would you mind looking in your book the next time you have a chance? And
which book are you looking in? Thanks for your help!
Tim
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of John Ivanoff
Sent: Wednesday, August 17, 2005 7:58 PM
To: [email protected]
Subject: Re: cfgridcolumn
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
----------------------------------------------------------
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
