I'm building a cfc wrapper for http://www.infosoftglobal.com/ fusionchart flash chart product version 3 beta, it's not out yet, anyone willing to help me test it out, I can probably get you a couple of free licenses for this product. Also they asked me to help them convert their ASP code to CF for the CF community, I told him I'll look at it, but I might not have the time to do it, it's a freelance per project basis.
Let me now if you want to help test, it sure does beat <cfchart> by a mile, nice looking charts too. Check out the code below. If you want I'll send a link to show how these charts look like.
<!--- Create a Query Object to pass data into the chart --->
<cfquery name="getTotalMonth" datasource="yourdsn">
select
year(DonationDate) as Year,
month(DonationDate) as month,
sum(donationAmount) as total_po
from
Donations
where year(DonationDate) = 2006
AND foodbank = 'AIDMX'
group by
year(DonationDate),
month(DonationDate)
order by
year(DonationDate),
month(DonationDate)
</cfquery>
<!--- Init the chart component and set some default values --->
<cfset fusionChart = createObject("component","fusionchart").init()>
<!--- setQuery is what ever query you are going to pass to genearate the xml --->
<cfset fusionChart.setQuery(getTotalMonth)>
<!--- Chart Type --->
<cfset fusionChart.setChartType("Column3D")>
<!--- Name of your Data --->
<cfset fusionChart.setDataName("Left(MonthAsString(month),3)")>
<!--- The Value of your data --->
<cfset fusionChart.setDataValue("total_po")>
<html>
<head>
<script src="" type="text/_javascript_"></script>
</head>
<body bgcolor="#ffffff">
<!--- This is the default chart --->
<cfoutput>#fusionChart.displayChart("chart1")#</cfoutput>
<!--- Add another chart by changing the chart type to Pie and then display the chart by using the displayChart function --->
<cfoutput>
#fusionChart.setChartType("Pie3D")#
#fusionChart.displayChart("chart2")#
</cfoutput>
<!--- Add another chart and adding more attibutes to it, notice I'm setting the X and Y Axis Name --->
<cfoutput>
#fusionChart.setyAxisName("Dollar")#
#fusionChart.setxAxisName("Month")#
#fusionChart.setChartType("Column3D")#
#fusionChart.displayChart("chart3")#
</cfoutput>
</body>
</html>
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
