It had to do with how I built my query using QueryNew() I was setting a column value like so: <cfset temp = QuerySetCell(rsGraphData,"dataoutput",MyQuery["data_" & curYear])>
Now when I added datatypes to my QueryNew() I saw that no matter what datatype I used it was always considered invalid. That got me thinking that CF might be thinking MyQuery["data_" & curYear] was a complex datatype. So I changed the code to this <cfset MyValue= MyQuery["data_" & curYear]> <cfset temp = QuerySetCell(rsGraphData,"dataoutput",MyValue)> and it worked like a charm!! Can anyone explain why the first snippet fails and the second works?? Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Monday, April 25, 2005 12:48 PM Subject: CFCHART in CFMX7 line graph > Hey All, > > I'm getting a really descriptive error when trying to fire up a line > graph via cfchart: > > For input string: [EMAIL PROTECTED] > > The query being used is a QofQ and has 2 columns. > > Here's the calling code: > > <cfchart > format="Flash" > title="Historical and Projected Output" > xaxistitle="Year" > yaxistitle="Output (tonnes)" > chartheight="400" > chartwidth="600" > showlegend="false" > labelformat="number" > style="default"> > <cfchartseries type="line" query="rsGraphData" > itemcolumn="datayear" valuecolumn="dataoutput"></cfchartseries> > </cfchart> > > If I switch "datayear" and "dataoutput" in the cfchartseries tag, the > graph will display (but obviously it's meaningless....but if I leave them > the way they should be I get that error???? > > Any thoughts? > > TIA > > Cheers > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > phone: 250.480.0642 > fax: 250.480.1264 > cell: 250.920.8830 > e-mail: [EMAIL PROTECTED] > web: www.electricedgesystems.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:204360 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
