473,372 Members | 953 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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 5946
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

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

Similar topics

1
by: noise | last post by:
Hello, I have problem with drawing running graph. What I want to draw is: I have an object O which as a real number r associated with it. In the main() (in main class) i have a for loop which do...
1
by: balakrishnan.dinesh | last post by:
Hi frnds, Im creating function to plot line graph in javascript . I have marked the points in graph. but what i need to do is, i want to draw the line between those marked point, but i dont...
9
by: balakrishnan.dinesh | last post by:
Hi frnds, I want to draw pie graph or line graph through javascript. Can anyone give me a sample code for these charts. Thank you Dinesh
0
by: suedasszyy | last post by:
Haiiii.... i'm new for VB.net. can someone help me to solve those question? is it possible to draw a graph such as Sin graph using console application? if not, how can i draw a graph...
4
by: hastalavista | last post by:
HI I'm very new to C# and I've got a big project to do in C# for uni until july. I've been trying do draw lines in C# (arrows to be precise). I can draw them allright but once I minimize the...
1
by: berry | last post by:
Hi all.. How to draw a line graph? My axis-x is the daily hour from 8am to 8pm. Can i use a XY mschart type to draw it? Or I must use a picture box to draw it? If with XY chart type, how to draw?...
7
by: =?iso-8859-1?Q?Vicente_Garc=EDa?= | last post by:
Hi, I need to programmatically draw a graph (his nodes and his edges) from dynamic XML file. The graph is very complex and I don't know how I could do this task. Any ideas please? Microsoft...
106
by: bonneylake | last post by:
Hey Everyone, Well i don't know if my question should be in javascript/ajax or coldfusion, i figure this is more of a coldfusion question. But if this is in the wrong section let me know an all...
3
by: mistusen | last post by:
the nodes of the graph has got x and y coordinate.we'll have to draw a directed graph with the nodes in java.where can i find the source code or what is used to draw the graph?plz suggest.how can i...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.