|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
August 31st, 2004, 01:31 PM
|
|||
|
|||
|
using CFCHart
Hi there. I am using cfchart to show a dynamic pie graph using the cfquery tag to show demographics based no Race. I have like 9 white, 6 black, 3 hispanic, etc. but when I show the bar graph it just shows me 1, 2, 3, 4, 5, 6, 1-6 being the values assigned to each race. It doesnt add how many 1's there are and show that in a pie, here is my code. I tried looking for other examples is this a problem with my sql code?
jack Code:
<cfquery name="race" datasource="vacancy"> select raceNum from dbo.Flow_log </cfquery> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <hr size="1" noshade> <cfdump var="#race#" label ="Race Demographics"> <CFCHART SHOWBORDER="yes" show3d="yes" chartwidth="600" chartheight="400" pieslicestyle="sliced"> <cfchartseries type="pie" query="race" itemcolumn="raceNum" valuecolumn="raceNum"> </CFCHART> </body> </html>
|
|
#2
August 31st, 2004, 01:42 PM
|
|||
|
|||
|
got it ...
Kiteless u must hate my entries by now. See i get really frustrated and then all of the sudden after I have posted I think of ways to do stuff. well this is how i did it in case anyone wants to use cfchart in the future:
<cfquery name="race" datasource="vacancy"> select race, count(*) AS raceNum from dbo.Flow_log where racenum is not null group by race order by race; </cfquery> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <hr size="1" noshade> <cfdump var="#race#" label ="Race Demographics"> <CFCHART SHOWBORDER="yes" show3d="yes" chartwidth="600" chartheight="400" pieslicestyle="sliced"> <cfchartseries type="pie" query="race" itemcolumn="race" valuecolumn="raceNum"> </CFCHART> </body> </html>
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > using CFCHart |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
