The table definition is:
CREATE TABLE [QAnswerExp] (
[QNo] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[QA] [int] NULL ,
[QB] [int] NULL ,
[QC] [int] NULL ,
[QD] [int] NULL ,
[QE] [int] NULL ,
[QF] [int] NULL ,
[QG] [int] NULL
) ON [PRIMARY]
GO
QA QB QC QD QE QF QG QNO
1 2 1 1 12 1 1 0 Q21
2 2 4 4 2 3 3 0 Q22
3 8 2 5 1 0 1 1 Q23
tia
On 5/19/05, Ryan Duckworth <[EMAIL PROTECTED]> wrote:
> Daniel, Your data is bad. I just ran the code that I posted below on
> CF 6.1 & 7.
>
> I just put some junk data (all numeric) in a test query and it graphs
> perfectly.
>
> Send me this: I guarantee you have some non-numberic values in your query!!!
>
> <cfquery name="qryAnswerExp" datasource="SCSurvey">
> select * from QAnswerExp
> </cfquery>
>
> <cfdump var="#qryAnswerExp#">
>
>
>
> Ryan Duckworth
> Macromedia ColdFusion Certified Professional
>
> Uhlig Communications
> 10983 Granada Lane
> Overland Park, KS 66211
> (913) 754-4272
>
>
>
> <cfset qryAnswerExp = QueryNew("QA,QB,QC,QD,QE,QF")>
> <cfset newRow = QueryAddRow(qryAnswerExp)>
> <!--- set the cells in the query --->
> <cfset temp = QuerySetCell(qryAnswerExp, "QA", "1")>
> <cfset temp = QuerySetCell(qryAnswerExp, "QB", "5")>
> <cfset temp = QuerySetCell(qryAnswerExp, "QC", "20")>
> <cfset temp = QuerySetCell(qryAnswerExp, "QD", "3")>
> <cfset temp = QuerySetCell(qryAnswerExp, "QE", "45")>
> <cfset temp = QuerySetCell(qryAnswerExp, "QF", "87")>
>
> <cfchart
> xaxistitle="Question: Q21 ~ Q23"
> yaxistitle="Counts"
> scaleFrom="0"
> gridlines="10"
> rotated="no"
> show3D = "no"
> showLegend = "yes"
> showMarkers = "yes"
> SHOWXGRIDLINES="yes"
> SHOWYGRIDLINES="yes"
> labelFormat="number"
> CHARTWIDTH="900"
> CHARTHEIGHT="400"
> SHOWBORDER="yes">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QA"
> markerStyle = "diamond"
> serieslabel="A"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QB"
> markerStyle = "diamond"
> serieslabel="B"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QC"
> markerStyle = "diamond"
> serieslabel="C"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QD"
> markerStyle = "diamond"
> serieslabel="D"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QE"
> markerStyle = "diamond"
> serieslabel="E"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QF"
> markerStyle = "diamond"
> serieslabel="F"
> paintStyle="raise">
>
> <cfchartseries
> type="bar"
> query="qryAnswerExp"
> itemcolumn="QNo"
> valuecolumn="QG"
> markerStyle = "diamond"
> serieslabel="G"
> paintStyle="raise">
>
> </cfchart>
>
>
> > > On 5/18/05, Daniel Kang <[EMAIL PROTECTED]> wrote:
> > > > When I run cfcharts, I am getting the error below. Please let me
> > > > know how to debug this.
> > > >
> > > > tia
> > > >
> > > >
> > > > Expected = instead of <(0x3C) In line:1 position:75. Stack:<xml><row><6>
> > > > The error occurred in
> > > > D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm: line 166
> > > >
> > > > 164 : markerStyle = "diamond"
> > > > 165 : serieslabel="3 to 7 yrs"
> > > > 166 : paintStyle="raise">
> > > > 167 : </cfchart>
> > > >
> > > > Stack Trace at
> > > > cfStatChartQ212ecfm288395228.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChartQ21.cfm:166)
> > > > at
> > > > cfStatChart2ecfm1445877973.runPage(D:\Inetpub\wwwroot\SafetyClimateSurvey\StatChart.cfm:101)
> > > > java.lang.RuntimeException: Expected = instead of <(0x3C)
> > > > In line:1 position:75. Stack:<xml><row><6>
> > > > at
> > > > com.gp.webcharts3D.xml.ExXmlParser.throwParseException(ExXmlParser.java)
> > > > at com.gp.webcharts3D.xml.ExXmlParser.unexpected
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:207231
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
