CGGRID Mystery

Posted on 2011-04-26
Last Modified: 2012-05-11
Hi (again),
I have a CFGRID table that uses a remote cfc to populate it.  One of the columns I'd like to contain "Yes" or "No" (without the quotes).

No matter how I try, it display in the grid as "true" or "false" (without the quotes).  If I change the value to Yess or Noo it displays OK.

Has anyone heard of this or have a clue.  I dumped the query results and the QueryConvertForGrid results and everything looks good until the actual display?

Below is a section of code to give you the idea

Thanks again for your expertise,

<cfloop query="getProds">
      <cfset queryaddrow(format)>
	    <cfset querysetcell(format,'Order',getProds.OrderId)>
        <cfset querysetcell(format,'ProdName',getProds.ProductName)>
        <cfif getProds.SubInd eq "true">
          <cfset YNsubInd = "Yes">
          <cfset YNsubInd = "No">  
        <cfset querysetcell(format,'SubInd',YNsubInd)>
	    <cfset querysetcell(format,'Sdate',getProds.Sdate)>
	    <cfset querysetcell(format,'Edate',getProds.Edate)>

        <cfset querysetcell(format,'QTY',getProds.QTY)>

Open in new window

Question by:hefterr
    LVL 1

    Author Comment

    FYI.  Ifound this link with the same problem :

    I can't believe ut's this complicated!!!!!

    LVL 39

    Accepted Solution

    Just taking a guess here, how about adding something to force it to think of Yes / No as strings instead of booleans.   Perhaps adding a space around the word?  " Yes " or  " No "  ? or a non-breaking &nbsp;  or an underscore "_Yes_"  ?   Something that that to fudge the results?
    LVL 1

    Author Comment

    I like the space around the " Yes " / " No " as this will appear as per specs.  I don't have access now so I'll try in the morning.  But it sounds promising.

    LVL 1

    Author Closing Comment

    added a space before and after the yes/no and it worked fine.  Thanks for the clever solution!


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
    Hi, Even though I have created this Tutorial on My personal Blog, Some people might not able to find my website, So here i am posting it again Today, from the topic it is very clear that i will be showing you here the very basic usage of how we …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now