Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
jgarciam #1
CFCHART AND DECIMALS
Hello everybody
CFCHART is not working with decimals values, probably is a problem with the
spanish regional settings that the decimal separator character is the "," and
the thousand separtor is ".". It is curious that the values passed to the
CFCHART are real numbers and not formatted strings.
Does anybody kno how to avoid this ?
Here is the code that sure works in a computer without Spanish regional
settings
Regards
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<cfset valor_1=30004/4567>
<cfset valor_2=30204/4587>
<cfset valor_3=30024/4597>
<cfset valor_4=30104/4527>
<cfoutput>
#valor_1#<br>
#valor_2#<br>
#valor_3#<br>
#valor_4#<br>
</cfoutput>
<cfchart xoffset="0" yoffset="0.02" show3d="yes" showlegend="yes"
chartheight="400" chartwidth="800"
backgroundColor="white"
xAxisTitle=""
yAxisTitle="avg milligrams"
font="Arial"
gridlines=6
showXGridlines="yes"
showYGridlines="yes"
showborder="yes"
seriesPlacement="cluster"
format="png"<cfchartseries>
type="bar"
seriesColor="##FF8000"
paintStyle="plain"
seriesLabel="Average(mg)/Compound">
<cfchartdata item="valor_1" value="#valor_1#">
<cfchartdata item="valor_2" value="#valor_2#">
<cfchartdata item="valor_3" value="#valor_3#">
<cfchartdata item="valor_4" value="#valor_4#">
</cfchartseries>
</cfchart>
</body>
</html>
jgarciam Guest
-
MOD operator and decimals
Trying to determine if a remainder exists when dividing two numbers with decimals. The MOD function is displaying a remainder, but the numbers are... -
CFINPUT and decimals
Hi.. I am encountering an odd problem... I have a series of CFINPUT statements in a form...The table that the data for the form comes from... -
Decimals not Getting into ASP
We have an ASP page that grabs data from an Oracle 9i table and then dumps it into another. It had been working great until we swapped out servers.... -
how to keep decimals from rounding
Is there a way to surpress round() or number_format() from rounding decimal places? I have a value of ".253338" being returned via a calc... -
Problem with decimals
Kathleen, Your table field should be defined as Numeric/Single or Numeric/Double with decimals = 2... or just leave decimals as "Auto", and format...



Reply With Quote

