Does this app cost money. I don't see on the website where you can buy it,
just a free download. It looks nice, and would be cool to use, but I'll
stick with cfgraph for now if it costs anything.

Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire

-----Original Message-----
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 1:35 PM
To: CF-Talk
Subject: Re: Weight Loss <CFGRAGPH>


Although CFGRAPH is pretty cool and a welcome addition to ColdFusion, there
 are still quite a few limitations to that tag. This is one of them.

What you are wanting to do is to have two valuecolumns on the same chart, a
nd this is something that CFGRAPH does not do. What you can do is to create
 two graphs, one showing weight loss and the other weight goal. You would h
ave all the people in the database lumped into one chart for each category.
 The code example below gives you two charts, one on top of the other. If y
ou want to do some really cool things with charts and graphs, for now you w
ill need to get a third party charting application. The one we use here at 
Baylor is PopChart by Corda Technologies (www.corda.com). It is really good
 It is a JAVA application that runs on the web server (or any server for t
hat matter, you just have to point to it in your code). It works well with 
CFM, ASP, JSP and HTML.  It also comes with a cool builder tool that is als
o a JAVA application. You feed in the necessary parameters and it creates t
he necessary JavaScript for you.

Code example:

<!--- Query the DB for the informaton --->
<cfquery dataSource = "SomeDSN" Name = "qSomeName">
 Select *
> WeightLoss
 order By F_Name
 </cfquery>

<!--- Create the first graph --->
  <cfgraph type="HORIZONTALBAR" query="qSomeName" valuecolumn="Weight
_Lost" itemcolumn="F_Name" showvaluelabel="Yes" valuelabelfont="Arial
" valuelocation="ONBAR" scaleto="300" itemlabelfont="Arial" itemlabel
orientation="HORIZONTAL" title="Weight Loss Progress Chart" titlefont
="Arial" fileformat="Flash" depth="5" colorlist="red,green,blue,yel
low,orange">
 </cfgraph>
 
 <!--- Create the second graph --->
 <cfgraph type="HORIZONTALBAR" query="qSomeName" valuecolumn="Weight_
Goal" itemcolumn="F_Name" showvaluelabel="Yes" valuelabelfont="Arial"
 valuelocation="ONBAR" scaleto="300" itemlabelfont="Arial" itemlabelo
rientation="HORIZONTAL" title="Weight Goal Progress Chart" titlefont
="Arial" fileformat="Flash" depth="5" colorlist="red,green,blue,yel
low,orange">
 </cfgraph>

Another thing that you can do is to output the information into a table abo
ve the charts, and you can also make it a drill down chart, then you could 
pass in the User_ID parameter in the URL and create another chart for just 
the individual or a table with the necessary information.


--- Original Message ----------------------------------
From: "Ann Harrell" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 7 Feb 2002 11:24:52 -0500

I'm in the thinking stage of a small project for a group of friends. I want

to keep it fairly simple. It would be in Access

Person1
WeightLost (bar graph)
WeightGoal

Person2
WeightLost
WeightGoal

and I would like to display this in cfgraph. Is this possible?

Ann Harrell, USA
Phone: 219.342.0618

A society that will trade a little liberty for a little order will lose
both, and deserve neither.
--- Thomas Jefferson, in a letter to Madison


______________________________________________________________________
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to