I'm using the following to try to generate a pie chart. The first query is
taking the types of roles available and the second query is supposed to get the
answers. I am getting a list of the available roles, however, it is not
generating the answers in pie chart...any ideas? CF MX 6.1 W2K Server

<cfquery name="theseRoles" datasource="#dsn#" dbtype="ODBC">
SELECT *
FROM survey_Roles
ORDER BY RoleID
</cfquery>
<tr>
<td align="center" colspan="2" style="border-left: 1px solid
rgb(0,0,0); border-Right: 1px solid rgb(0,0,0); border-bottom: 0px solid
rgb(0,0,0); border-Top: 0px solid rgb(0,0,0)">
<table border="0" bordercolor="000000" cellpadding="5"
cellspacing="0" width="100%" height="300">
<tr>
<td align="center" valign="top" class="Fontsm1">
<cfif #theseRoles.RecordCount# is not 0>
<cfchart format="flash" xaxistitle="Role" yaxistitle="Total">

<cfchartseries query="theseRoles" type="pie" itemcolumn="Role"
valuecolumn="#theseRoles.RecordCount#">
<cfloop query="theseRoles">
<cfquery name="thisRole" datasource="#dsn#" dbtype="ODBC">
SELECT *
FROM survey_Results_CompanyInfo
WHERE customer_Role = '#RoleID#'
</cfquery>
<cfchartdata item="#theseRoles.Role#"
value="#thisRole.RecordCount#">
</cfloop>
</cfchartseries>
</cfchart>
</cfif>
</td>
</tr>
</table>
</td>
</tr>