Thanks for looking - it didn't like the quotes either.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of John Ivanoff
Sent: Wednesday, August 17, 2005 9:18 PM
To: [email protected]
Subject: Re: cfgridcolumn
I'll take a look in the morning. try quotes around the number 1, maybe
it's a "string."
On 8/17/05, Tim Starling <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
----------------------------------------------------------
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
