User Guide

72 Chapter 2: ColdFusion Tags
For all other color values, you must enter the hexadecimal value. You can enter a six-digit value,
which specifies the RGB value, or an eight-digit value, which specifies the RGB value and the
transparency. The first two digits of an eight-digit hexadecimal value specify the degree of
transparency, with FF indicating opaque and 00 indicating transparent. Values between 00 and
FF are allowed.
For more color names that are supported by popular browsers, go to www.w3.org/TR/css3-color
You can specify whether charts are cached in memory, the number of charts to cache, and the
number of chart requests that ColdFusion can process concurrently. To set these options in the
ColdFusion Administrator, select Server Settings > Charting.
Example
<!---The following example analyzes the salary data in the cfdocexamples
database and generates a bar chart showing average salary by department. The
body of the cfchartseries tag includes one cfchartdata tag to include data that
is not available from the query. --->
<!--- Get the raw data from the database. --->
<cfquery name="GetSalaries" datasource="cfdocexamples">
SELECT Departmt.Dept_Name,
Employee.Dept_ID,
Employee.Salary
FROM Departmt, Employee
WHERE Departmt.Dept_ID = Employee.Dept_ID
</cfquery>
<!--- Use a query of queries to generate a new query with --->
<!--- statistical data for each department. --->
<!--- AVG and SUM calculate statistics. --->
<!--- GROUP BY generates results for each department. --->
<cfquery dbtype = "query" name = "DataTable">
SELECT
Dept_Name,
AVG(Salary) AS avgSal,
SUM(Salary) AS sumSal
FROM GetSalaries
GROUP BY Dept_Name
</cfquery>
<!--- Reformat the generated numbers to show only thousands. --->
<cfloop index = "i" from = "1" to = "#DataTable.RecordCount#">
<cfset DataTable.sumSal[i] = Round(DataTable.sumSal[i]/1000)*1000>
<cfset DataTable.avgSal[i] = Round(DataTable.avgSal[i]/1000)*1000>
</cfloop>
Teal ##008080
White ##FFFFFF
Yellow ##FFFF00
Color name RGB value