Using CF8, I want to produce a graph that displays the disk usage, in
megabytes, per client. The clients are the directories within D:\inetpub\sites.
I've looked through the docs and found examples only using DB queries. I am
using to get a list of directories.
<cfdirectory action="list"
directory="#expandPath("../../")#"
name="webDirectories">
<cfquery name="getInfo" dbtype="query">
select sum(size) as total, name
from webDirectories
group by name
</cfquery>
<h1>Web Server Disk Usage Analysis</h1>
<!--- Bar graph, from Query of Queries --->
<cfchart format="flash"
xaxistitle="Client"
yaxistitle="Disk Usage">
<cfchartseries type="bar"
query="getInfo"
itemcolumn="name"
valuecolumn="size">
<cfoutput query="getInfo">
<cfchartdata item="#name#" value=#Round(total/1000)*1000#>
</cfoutput>
</cfchartseries>
</cfchart>
I would like to have the clients listed in the x-axis and usage on the y-axis.
How can I achieve this?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5606
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
