Skip to main content
Inspiring
March 30, 2008
Question

CFCHART value column issue

  • March 30, 2008
  • 1 reply
  • 383 views
Basically, a value column which should be 0.02, is being displayed as 0.002 on the graph.

1. The database shows 0.02
2. The cfdump of the query shows 0.02
3. Here's how the bar is being called:

<cfchartseries type="bar"
query="qryData"
valuecolumn="some_field"
serieslabel="Label"
seriescolor="00ff00"
itemcolumn="item">
</cfchartseries>
    This topic has been closed for replies.

    1 reply

    Participating Frequently
    March 31, 2008
    <cfscript>
    myQuery = QueryNew("");
    QueryAddColumn(myQuery,"name",ListToArray("A, B, C"));
    QueryAddColumn(myQuery,"val",ListToArray("0.02, 0.2, 0.002"));
    </cfscript>

    <cfchart>
    <cfchartseries type="bar"
    query="myQuery"
    valuecolumn="val"
    serieslabel="Label"
    seriescolor="00ff00"
    itemcolumn="item">
    </cfchartseries>
    </cfchart>


    This works for me without any problem on CF8.