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
