Graphs Based On Data Of An Array?
Does anybody know of techniques (or websites) where a graph is generated based on data of an array?
View RepliesDoes anybody know of techniques (or websites) where a graph is generated based on data of an array?
View RepliesI need to create a chart/graph with the following data from my database:
Each record is opened and then closed at a later stage. I then calculate the time it took from when the record was entered to when it was closed.
Now i need a pie chart to display how many records was closed in certain times. for example 10 records was closed within the first 10 minutes, 2 in 20 minutes and so on.
this also is to happen for dates that the user entered. i.e a Weekly report and a monthly report.
Any advice and help will be appreciated. I found alot of examples of hardcoded graphs but none extracting data from database.
So first i need to count the records that fits each section of minutes and then use that data to draw my graph?
I am having an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. Code:
View Replies View RelatedI'm looking to display information pulled from a database based on
information the user puts into a text box. The user will enter their
sales rep number and I want to hit a table and return their name as
soon as they tab off of the text box. Any ideas or help would be
appreciated
I am doing a project that uses ASP VBScript on Dreamweaver. I try to display data based on the hyperlink on the previous page, where I click on the hyperlink("ID of the informationfile") and the following page will show the detailed information of this particular file.
However, I can't display the next page even if I add the hyperlink and the required parameter on the records that are shown on the first page. I need to ask how can I display the detailed information based on the hyperlink, or in fact the fileID from the first page ??? Code:
I have an asp page that displays informaton from an Access database. I want to create a form that allows users to display only data that matches their search criteria.
I have made many forms like this in Front Page with the Database results wizard, but I want to manually code it. Code:
i have a page which displays a list of events searched for by a particular date. we usually have a lot of events and i don't want the user to have scroll through all of them, especially if they're interested in a particular type of event.
i have created a dynamic drop down menu which consists of all the event types. how can i got about displaying the events returned by the query to a specific event for that date.
so for example, if some one searches for 03/08/2005, they will initially get a list of all events for that day. if they click on "Closed" from the drop down menu, it will display all the "Closed" events for 03/08/2005.
i take data from the sql server like this:
....
set con=Server.CreateObject("adodb.connection")
set rs=Server.CreateObject("adodb.recordset")
SqlExp = "SELECT * FROM content"
rs.Open SqlExp,con,3,3
Response.Write rs("PageName")
....
now, sure it works nice with only one row, but if i have several row in my Table, my guess i need to put data into an array?so, how do i put my fields into an array and display them?
can i put my operators into an arry, as i want to loop them later in a loop. but i have problem declearing the data type of the arrys.
Dim operatorsArray(4) As ?????
operatorsArray(0) = "+"
operatorsArray(1) = "-"
operatorsArray(2) = "*"
operatorsArray(3) = "/"
what should the data type be to work. can i have an example of how i am going to
use it.can it be done this way eg.
2 operatorsArray(0) 3 operatorsArray(0) 4 operatorsArray(0)does the above interperate as 2 + 3 + 4?
In PHP, we can use print_r($HTTP_POST_VARS) to show all the info submitted by form. IN asp, how can we do that?
View Replies View RelatedOk, given a string such as this -
203_2_0_0_1_5_0_234_0_8_22_2_0_3_345_2_3_0_0_0_9
Each three digit number in the string represents a unique ID of a file in a database. Following each ID are six digits, all seperated by a "_" . Each file will ALWAYS have six subsequent integers, such as above ID "234" has "_0_8_22_2_0_3_" following it.
What I am trying to figure out is given a string of any length of this specific pattern, how to decarle a multi dimensional array that would hold each ID and its corresponding digits.
To clarify a little further, this is from a shopping cart for a photographer. Each "ID" represents an image, each of the six corresponding numbers for each ID represents a qty for an image print size, ie., 4 4x6's, 5 5x7s, 0 8x10s, 1 16x20, 23 20x30's, 48 wallets. Oh, and the image ID's are not necessarily always going to be 3 digits, they could be of any lenght integer...
Im declaring an array, store some values in it and then I save the array
in a session variable. On an other page I store the data of the
session in a new multiple dimension array.
All data are saved correctly in the array of the 1st page. But in the
new array of the 2nd page there is only one entry. Does anybody knows
why??? Here the code example Code:
I've done all the reporting bits on counting and all. I would like to know how to create graphs for that information. I m at a total lost on how to display a graphs on the web page.
View Replies View RelatedDoes anyone know of an easy way to display graphs using asp code. Is there any free packages on the web that can be downloaded for the purpose of displaying results in a graphical format. Or is it better to use pure asp code??
View Replies View Relatedany way of creating graphs in MS Access and desplaying on a web page and all of this done by ASP!!
i want a graph with multiple comparisons such as a bar and a line graph combined...Possible???
Hi I would like to display 2 dimensional graphs in ASP using the data from the database!.
Any body having a template!
I'm trying to find thorough documentation for creating graphs using
serverside Excel from ASP. Any book recommendations?
A well-documented COM wrapper would be nice if it allowed us to create
may different types of graph, e.g. Wind Rose (for wind direction),
thermometer, as well as standard pie, line, bar charts. I've found a few
examples of charting code on websites and at MS, but none of them
contain a thorough explanation, and our database/ASP guy wants more
documentation.
I have a db of prices for a material updated weekly, i am trying to create a graph to show the prices visually. i tried with JavaScript Diagram Builder, but didnt succeed,
does anybody have other ideas to how to do so? or have good knowledge on how to do it with the Diagram Builder?
I have managed to succesfully return data from a database with an SQL SELECT string, and now I was wondering if there is a simple way to graph the data?
Does ASP have any objects that will help out with graphing, or would I have to to draw it out manually?(if that could be done). Or should I not try to do it myself and look at a 3rd party solution for graphs?
I am trying to figure out how do I create graphs and charts in ASP without having to use third party solutions. I was told that I can create dynamic graphs and charts using ASP.Net but when I read up on this, came up at a dead end. Any ideas anyone?
View Replies View RelatedDoes anyone know of any asp plugins for graphs, i.e. in php there is something called jpgraph where numbers can be given and graphs drawn...
I am creating a statictics section on my website..
How can I develop Graphs using ASP 6.0, which I am using SQL 2000 as my database? Is there is any free tool to develop graphs using ASP 6.0?
View Replies View RelatedDoes any one perhaps know how to display data from a db in a asp page in graphs, or perhaps know of a resource where I can find more information on this topic?
View Replies View RelatedI want to display the data from Access in form of Bar charts and Pie charts. I know this is possible by using the OWC components. But i am not familiar to them.Can anybody give me an outline/example of how to do this?
View Replies View RelatedDoes any one perhaps know an easier way of showing 6 different graphs that all display different information with out having to execute 6 different connections to the db?
View Replies View RelatedIs there a method using asp to do line graph?
View Replies View RelatedDoes anyone have any experience building bar graphs or charts in asp? Or has anyone used a dynamic bar chart generator that is easy to use and easy to integrate into a webpage?
View Replies View RelatedI'm trying to use Activer Server Pages (ASP) to display a graph based on user's selection criteria. To achieve this, I would like to use Office Web Components (OWC 9 or 10), a Microsoft ActiveX component. My questions are:
* Can you use it with NT operating systems or Must it be in Windows 2000/XP?
* Do anyone has experience in using it? and if yes, Are they easy and reliable to use?
* Are there any other free components out there?
I have recently found myself involved with a very small company who is being contracted by a very large company to develop a PowerPoint type application for their sales people (18 slides and about 3,000 active users) which must include charts and graphs. It doesn't have to be in real time and we may render the graphics each night instead of on the fly. The slides will be dynamic and represent up to 30 different companies querying about 29,000 rows of data per company.
I oddly enough don't feel as worried as I probably should be.
Suggestions, Possible Pitfalls, and Previous Experience building an application like this.
Working off of MS SQL and planning to do it all in ASP.
What is a straightforward way to generate a simple line
graph from provided x-y data points in an ASP script.
I'm in desperate need of knowing if its possible to generate
custom circular diagrams and BullsEye charts using ASP (or
ASP.NET) on a webpage.
I must be able to build a graph that is constructed with
several inner circles, segments and bars that start from the
center.
Any method will do as long as I get the right shape. The graph
doesn't have to be intelligent in anyway.
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code: