Does 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 RepliesI'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 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.
I 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?
Does anybody know of techniques (or websites) where a graph is generated based on data of an array?
View Replies View RelatedWhat 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 have a problem with DSNless connections. I used the code below but doesnt works.
An error message appears in browser...
<%
conn = Server.CreateObject("ADODB.connection");
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:path odatabase.mdb";
conn.Open;
......
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it
work using DNS-Less connection? Code:
Right, which do you use? If your using DSNless, then STOP! It's SLOWING down your code and making it UGLY!!
Why? Lets look...
UGLY!
Which looks better
[vbs]
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("./data/vote.mdb")
[/vbs]
or
[vbs]
"DSN=databaseStuff"
[/vbs]
Its also easier to manage and will cause less typing errors. Think about it, it makes sense!
SPEED
Everytime you run a DSNless connection inside an ASP page the connection string needs to be verified,but a DSN connection is only verified when it is created! Meaning the DSN connection is indeed faster.
I am not sure what is wrong with this code. I have tested it at home, used in on previous webpages, and with previous employers. But I am getting this error at my current employers server: Code:
View Replies View RelatedI've been using ASP.NET for a couple years now and I'm trying to fall back into ASP for a new position I've acquired...and I'm having a bit of trouble remembering. I'm running to a problem where the basic logic is as follows:
Query
Do While Not rs.EOF
Query based on value in rs
Another query based on value in rs
Loop
There is no explicit connection object, they all use the same connection string however. When I limit myself to one query within the Do/Loop, I don't have any problems. However, when I add another query in there, it bombs with: Operation is not allowed when the object is open.
I'm assuming it's referring to the connection string being reused, but why would it allow one additional connection, but not two. I can't really close this connection before needing to requery. Is there anyway around this, or am I missing something entirely?
i am maintaining a system that was developed using dream weaver. a lot of the asp ado code looks like this:
set sp_yellow = Server.CreateObject("ADODB.Command")
sp_yellow.ActiveConnection = MM_MHR_CONN_STR_STRING
sp_yellow.CommandText = "Sp_HPMSQ007_GetSystemConstants"
sp_yellow.CommandType = 4
sp_yellow.CommandTimeout = 0
sp_yellow.Prepared = true
sp_yellow.Parameters.Append
sp_yellow.CreateParameter("@RETURN_VALUE", 3, 4)
sp_yellow.Parameters.Append sp_yellow.CreateParameter("@P_NAME_TXT",
129, 1, 17, "MLSTN_YELLOW_DAYS")
set rst_yellow = sp_yellow.Execute
someone on another forum expressed that dreamweaver "tends to drive the programmer to creat implicit connections and their effect on performance".could someone explain this to me? a provide some better code? (we no longer are required to use dream weaver to develop code for the app).
in my main page i need to retreive record set from the database as well as search for products. but the recordsets i need to retrieve are located in a different table then the products i need to search. is this possible to do ?
View Replies View RelatedI am programming a rather large site which will hopefully attract thousands of visits per day. I have been told by other people that MS access begins to struggle once it has about 15 active connections.
Since I am currently using MsAccess to test my scripts along with IIS 5.0 or whatever it is, I guess that at some stage I am going to have to convert all my stuff so that the data is in an SQLServer Database, and that the scripts can read and write to it. could anyone tell me what the transition is like. should I consider using SQL Server from the beginning or will I just have to change a few lines on each page.
On my website, I want to provide 3 pieces of statistics that will require 3 queries to my SQL database. As much as I'd like these to be live, they are part of a footer that will load each time for about 10 pages on my site. I am thinking that, although they are simple queries, it may be just too much.
What do you recommend? I could open the connection, run the query and then close it, each time. Would this be a recommend plan? Or, should I create a daily task that builds a simple text file with those query results and just pull those in each time the footer is loaded? This would not be live, but I can deal with it.
I get somthing like "Max Connection limit is reached" error msg when trying to access a page. I wonder it is got to do with winxp pro sp2 patch which only limit 10 tcp connections? Running ms access as database and IIS 5.1.
View Replies View Relatedhow to close all open database connections without referring to each connection by name across an entire server?
View Replies View RelatedI use a global.asa file to connect to SQL Databases. how would I go about connecting to multiple SQL Databases within a global.asa file?
View Replies View Related