This is a repost... can nobody help with this?
I'm having some trouble with CFCHART... coldfusion MX 6.1 Enterprise on
Linux ... I've never used it before, but I've got something pretty
simple and it's giving me a blank error message that looks like this:
Error Occurred While Processing Request
The error occurred in /vservers/superbowlmon/htdocs/test2.cfm: line 62
60 :
61 : <cfchart xaxistitle="Favorite NFL Team" yaxistitle="Votes">
62 : <cfchartseries type="bar" query="qry" valueColumn="QUESTION1_YES"
itemColumn="TEAM_NAME"></cfchartseries>
63 : </cfchart>
64 : <cfinclude template="below.cfm">
Here is the specific code:
<cfquery name="qry" datasource="#application.ezsite.primarydb#">
select
B.TEAM_NAME,
SUM(A.QUESTION1) as QUESTION1_YES,
COUNT(A.QUESTION1)-SUM(A.QUESTION1) AS QUESTION1_NO
from
SIGNEES A LEFT JOIN NFL_TEAMS B ON A.QUESTION5=B.TEAM_ID
GROUP BY B.TEAM_NAME
ORDER BY B.TEAM_NAME
</cfquery>
<cfchart xaxistitle="Favorite NFL Team" yaxistitle="Votes">
<cfchartseries type="bar" query="qry" valueColumn="QUESTION1_YES"
itemColumn="TEAM_NAME"></cfchartseries>
</cfchart>
What the heck is going on?
- Rick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203134
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
