Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

cfchart

Posted on 2007-07-30
2
Medium Priority
?
428 Views
Last Modified: 2013-12-16
hai all,

I have a query in coldfusion page as follows
<cfquery name="output" datasource="polo">
select comment_rank,count(*)total
from comments
group by comment_rank
</cfquery>

output as follows

comment_rank      total
-----------       ------
BAD                20
GOOD               60
OK                 20

how do i create a chart using above query as follows

bad in blue
good  in green
ok in yellow


thanks and please help me








0
Comment
Question by:faizershez
1 Comment
 
LVL 14

Accepted Solution

by:
Scott Bennett earned 2000 total points
ID: 19601387
<cfchart format="flash"
      xaxistitle="Comment Rank"
      yaxistitle="Total">

      <cfchartseries type="bar"
            query="output"
            itemcolumn="comment_rank"
            valuecolumn="total"
            colorlist="0000ff,00ff00,ffff00"/>
</cfchart>
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them (http://www.randhawaworld.com/) . I did keep the main js functions but made sever…
Originally, this post was published on Monitis Blog, you can check it here . It goes without saying that technology has transformed society and the very nature of how we live, work, and communicate in ways that would’ve been incomprehensible 5 ye…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question