September 6, 2008 10:25am pdt

1. SidFishes 208,881
2. gdemaria 205,594
3. Zvonko 205,210
4. _agx_ 103,710
5. Plucka 99,613
6. SBennett 49,530
7. zadoc 49,250
8. hielo 47,750
9. erikTsomik 31,210
10. Jester_48 27,025
11. pmascari 24,754
12. Mr_Nil 24,710
13. js_vaughan 24,550
14. dgrafx 16,675
15. pigmentarts 16,150
16. msfletch 15,920
17. Kerrdo 14,850
18. danrosent... 14,300
19. srikanthm... 12,950
20. b0lsc0tt 12,000
21. ee_rlee 10,500
22. asiderop 10,200
23. Yamagami 9,900
24. digicidal 9,550
25. rucky544 9,200

1. gdemaria 547,586
2. _agx_ 477,265
3. SidFishes 335,687
4. Zvonko 214,274
5. SBennett 212,175
6. Plucka 121,313
7. zadoc 76,380
8. pmascari 73,529
9. hielo 69,250
10. Jester_48 63,845
11. js_vaughan 54,950
12. erikTsomik 43,480
13. pigmentarts 36,698
14. dgrafx 31,250
15. danrosent... 28,200
16. digicidal 27,550
17. 73Spyder 26,575
18. angelIII 24,900
19. Mr_Nil 24,710
20. Mause 23,200
21. b0lsc0tt 22,472
22. R_Hos 21,150
23. mplungjan 18,125
24. rucky544 18,100
25. srikanthm... 17,800

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 …

	Title
1	cfchart help
2	Cfchart by zip problem
3	CFCHART or CFGRAPH
4	create cfchart
5	cfchart and axis labels
6	CFCHART issue

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

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

About this solution