If you downloaded the eval, login to the administrator and click on the
documents link. There is an explination of how to use CFgraph there. Or, try
this code.
<cfquery dbtype="dynamic" connectString="Driver=SQL Server;Server=PUT YOUR
SERVER HERE;database=northwind;username=sa"
name="ordertotals">
Select 'Max Title' as Title ,Max(subtotal) as Amount from [order
subtotals]
Union
Select 'Average Amount' as Title, AVG(subtotal) as Amount from
[order subtotals]
Union
Select 'Minimun Order' as Title, Min(subtotal) as Amount from [order
subtotals]
</cfquery>
<cfdump var="#ordertotals#">
<cfflush>
<p>
<cfgraph type="bar"
query="ordertotals"
showValueLabel="yes"
valueColumn="Amount"
itemColumn="Title"
showItemLabel="no"
gridLines="10"
scaleFrom="1"
scaleTo="5000"
graphHeight="300"
graphWidth="300"
fileformat="png">
</cfgraph>
Valid fileformat values for the release are PNG, JPG, FLASH. The GIF format
has been removed from the release version. The query below is using the
dynamic dytype where you do not need to specify a datasource name. This will
work if you are using SLQ 7.0 or up
-----Original Message-----
From: Jim Watkins [ <mailto:[EMAIL PROTECTED]>
mailto:[EMAIL PROTECTED]]
Sent: Friday, June 08, 2001 7:35 AM
To: CF-Talk
Subject: Re: CF 5 Cfgraph problem
I installed CF 5.0 subscription download and "Generator" was never
mentioned. Where do I get Generator to install it?
----- Original Message -----
From: "Tim Painter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, June 08, 2001 6:10 AM
Subject: Re: CF 5 Cfgraph problem
>
> You need to put the attribute "fileformat" in there. I think by default
it
> uses Flash, but that only works if you have Generator installed. Put a
> fileformat="jpg" or fileformat="png" and it should work fine.
> ----- Original Message -----
> From: "Jim Watkins" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, June 07, 2001 11:58 PM
> Subject: CF 5 Cfgraph problem
>
>
> > Should the following code draw a simple pie graph when executed? Or do
i
> > need something else?
> >
> > <cfgraph type="pie" title="Income by Department">
> > <cfgraphdata item="New Vehicle Sales" value=500000>
> > <cfgraphdata item="Used Vehicle Sales" value=250000>
> > <cfgraphdata item="Leasing" value=300000>
> > <cfgraphdata item="Service" value=400000>
> > </cfgraph>
> >
> > Jim Watkins
> > <http://www.ngtcollege.org> http://www.ngtcollege.org
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
