Advertisement

05.27.2008 at 12:13PM PDT, ID: 23435984
[x]
Attachment Details

CFChart is showing 1 when it should be showing 0

Asked by sonicimpulse in Cold Fusion Markup Language, Web Languages/Standards

Tags: coldfusion 8, mozilla, local host

I posted the code below.  For some reason when there is no value for a specific item the chart shows a total for that item as 1 instead of 0.  Is there a work around for this issue.  I posted my code below.

Start Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
<cfquery name="cell" datasource="security">
						SELECT DISTINCT name, SUM(cell) AS Total FROM tracker
						WHERE memberid=#memberid#
						GROUP BY name
						</cfquery>
                        <center>
                          <strong>Totals</strong> <br />
                          <cfchart 
		scalefrom=0
		scaleto=20
		font="arial"
		fontsize=16
		gridlines=10 
		show3d="yes"
		foregroundcolor="##0000CC"
		databackgroundcolor="##CCCCCC"
		chartwidth="550"
	>
                          <cfchartseries 
		type="bar" 
		query="cell" 
		valuecolumn="Total" 
		itemcolumn="Name"
		seriescolor="##33CC99"
		paintstyle="shade"
		/>
 
Keywords: CFChart is showing 1 when it should …
 
Loading Advertisement...
 
[+][-]05.28.2008 at 06:46AM PDT, ID: 21660326

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Cold Fusion Markup Language, Web Languages/Standards
Tags: coldfusion 8, mozilla, local host
Sign Up Now!
Solution Provided By: gdemaria
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628