Chart makes my page "inaccessible"

[PlastechFish]

I am almost done with the site I have been developing for the past week or so,
and it seems that I saved the worst for last. When I add a dynamic chart to my
index.cfm page, I get an error in MSIE: "The page cannot be displayed" (you
know, the usual when you misspelled a url). Then when I comment out my chart
and refresh, the page displays again. I am attaching my code, any idea why
this might be happening???

<cfchart rotated="yes" gridlines="11" scaleto="100">
<cfchartseries type="bar" query="poll" itemcolumn="r.vote_text"
valuecolumn="getpercent(vote_result, total)">
</cfchart>

getpercent() is defined as:
<cfscript>
function getpercent(num, total)
{
return (num/total)*100;
}
</cfscript>


Where total is a SUM() function in the database:
<cfquery name="poll" datasource="phpbb">
SELECT d.vote_id, d.topic_id, d.vote_text, d.vote_start,
r.vote_id, r.vote_option_id, r.vote_option_text, r.vote_result,
SUM(r.vote_result) as total

FROM phpbb_vote_desc d, phpbb_vote_results r
WHERE d.vote_id = r.vote_id
GROUP BY r.vote_option_id

ORDER BY d.vote_start DESC

LIMIT 1
</cfquery>


Any help would be awesomely apreciated....I am totally confused......

[PlastechFish]

Okay, this is weird. After realizing that my SQL was clearly off from what I
intended, I commented it and my chart out and replaced the dynamic chart with a
static one. I STILL GET THE SAME ERROR! Does CFMX have to be configured a
certain way to display charts?

[mxstu]

File this suggestion under the category of "it may not help...but it can't
possibly hurt" ...

You mentioned you're using Internet Explorer. Did you try turning off the
option [Show friendly HTTP error messages], just to make sure it's not hiding
the real error message?

[PlastechFish]

Good idea but no effect. I guess I could try reinstalling CF server tomorrow,
but I am hesitant to since I already had to once (it got glitchy and stopped
connecting to my DBs). Thanks for the idea though.

[mxstu]

Did you receive the same message when viewing the page with another browser as well?

[PlastechFish]

Mozilla: The document contains no data.

Opera: Could not connect to remote server
You tried to access the address [url]http://localhost:8500/DatingThreads/[/url], which is
currently unavailable. Please make sure that the Web address (URL) is correctly
spelled and punctuated, then try reloading the page.

It seems to me that the server is running into an error when it hits the
cfchart tag and is not returning anything to the browser. My other pages
(which don't includ cfchart) work fine though!

[mxstu]

Did you check the CF logs for exceptions after you run the cfm page with the
CFCHART? It might give you a better idea what the problem is. Also, there are
a few entries in the macromedia knowledgebase, relating to CFCHART, so you may
want to check there as well.

[PlastechFish]

Do you have a file called GraphData.cfm in your CFIDE directory? Cuz I just noticed......I don't.....

[mxstu]

Sorry, I don't have MX set up correctly on this box, so I can't check.

[PlastechFish]

Is there a way to get all the CFMX Dev edition files in zip format so I can extract what I need, or will I have to reinstall? Thank you so much for your help, man.

[mxstu]

Wish I could be of more help.

Not that I know of. I believe the developer edition comes in an
InstallAnywhere exe file, which I'm not that familar with. You could probably
check the web to see if it even possible to view/unzip the contents of this
type of file ( InstallAnywhere exe). Your best bet is probably a
re-installation. However, I know that when you start the installer it does
extract some files to the temp directory for your O/S. Exactly which files it
extracts, I don't know, but you might want to check there.

[prayank]

Hey try using <cfchart format="png"> or <cfchart format="jpeg">, if it works then it means you are having some problem with the "Flash" format of charts.

[PlastechFish]

Prayank,

You are brilliant. Thanks a million.