469,343 Members | 5,186 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,343 developers. It's quick & easy.

Coldfusion script to draw graph

Hi,

I am new to coldfusion. I need to query a table to get some datas and then draw a graph using that. Can anyone help me?

Thanks
Resmi318
Jul 17 '07 #1
9 5592
acoder
16,027 Expert Mod 8TB
What code have you got so far? What kind of graph/chart do you want to draw?
Jul 17 '07 #2
What code have you got so far? What kind of graph/chart do you want to draw?
Hi,

I dont have any code. A table is pesent. By querying that table I will get the x and y values to draw the graph. It should be a two dimensional line graph. The script should query the table and plot graph.
Jul 17 '07 #3
acoder
16,027 Expert Mod 8TB
Hi,

I dont have any code. A table is pesent. By querying that table I will get the x and y values to draw the graph. It should be a two dimensional line graph. The script should query the table and plot graph.
Give some details about the table and what values you need.
Jul 17 '07 #4
Give some details about the table and what values you need.
Hi,
Values will be like this

Week_type Net
25/05/2007 100
01/06/2007 150
08/06/2007 80
15/06/2007 120

These values will be present as two columns in the table.
i need to draw graph with these.

Thanks
Jul 18 '07 #5
improvcornartist
303 Expert 100+
You might be able to use the cfgraph or cfchartseries tag, depending on your version of ColdFusion.

cfgraph
cfchartseries
Jul 18 '07 #6
You might be able to use the cfgraph or cfchartseries tag, depending on your version of ColdFusion.

cfgraph
cfchartseries
Cold fusion version I am using is 7.
Operating system is unix.
Thanks
Jul 19 '07 #7
acoder
16,027 Expert Mod 8TB
Cold fusion version I am using is 7.
Operating system is unix.
Thanks
Then use cfchart and cfchartseries. Check the documentation and make an attempt. If you get stuck, post your code.
Jul 19 '07 #8
Then use cfchart and cfchartseries. Check the documentation and make an attempt. If you get stuck, post your code.
Hi,

I used cfchart and cfchartseries to draw the graph and I got it. Thanks everybody for helping.

Now I need to get an excel sheet with data of the query when the user clicks on the graph. How can I do that? I found out how to get data in excel sheet but how to get it when user click on the graph? Please advice me?

Thanks
Resmi318
Aug 6 '07 #9
acoder
16,027 Expert Mod 8TB
Hi,

I used cfchart and cfchartseries to draw the graph and I got it. Thanks everybody for helping.
Glad you got it working and by yourself too. Well done!
Now I need to get an excel sheet with data of the query when the user clicks on the graph. How can I do that? I found out how to get data in excel sheet but how to get it when user click on the graph? Please advice me?
If you can get data into an excel sheet using Coldfusion (or some other language), you can link to the url using (I think) the url attribute of the cfchart* tag.
Aug 6 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by noise | last post: by
1 post views Thread by balakrishnan.dinesh | last post: by
9 posts views Thread by balakrishnan.dinesh | last post: by
4 posts views Thread by hastalavista | last post: by
7 posts views Thread by =?iso-8859-1?Q?Vicente_Garc=EDa?= | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.