John,
I saw a nice example of the inline if at CFDJ on an example for an address
book. The IF statement is on page two of the article at: http://cfdj.sys-con.com/read/101342_2.htm
It looks like the idea in the previous email is correct but the syntax may be
off. Check out the article and maybe it will help...
----- Original Message -----
Sent: Thursday, August 18, 2005 8:47
AM
Subject: Re: cfgridcolumn
I couldn't get the inline if to work either so I'm going to
change my
position. Can I do that?
Would it be better to change the 1 to
Approved in the query? I was
also wondering if that approved can be changed
to pending in the form,
it needs to be converted to a 2 or is the grid just
used as a list?
Maybe add a table with approved and pending in it and tie
it to the
main table and rewrite the query.
I think in the long run
it'll be easier to maintain.
I thought I saw the inline in the MX7 WACK
but maybe I saw it used in CFDJ.
On 8/17/05, Tim Starling <[EMAIL PROTECTED]>
wrote:
> 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
>
>
>
----------------------------------------------------------
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
|
