I tried to find some components I can use to dynamically
generate chart or graph from database in ASP. It seems to
me that only some other companies have software on this
but Microsoft doesn't have any of them. Am I wrong?
Can anyone reccommend a decent chart/graph component to use with asp 3 (Not .net)
View Replies View RelatedCould anyone suggest me some asp graph components which take in data from a recordset by SQL query to a database and then display it in web browser.
Are there any freewares....?
Buying a license is the 2nd option......and preferably a component which allows customization..
I have a graph component: ChartDirector.... Which doesnt allow me to include any queries in the same asp file...
I need to generate a graph depending on the values in the database. Is there any free software related to this?
I tried some but in most of them we need to install the activex component. I am looking for software without any involvement of activex component.
Database and all the pieces are in place. On the results page the query returns the % calculation for a question (displayed) options (each individually).
I need to display bar graph, this is here that i am getting into problem. The background color would be #555555. How can i apply this color to certain % of the container as background?
I have made a page to display a chart based on data from my SQL-server. I have used Office Web-component graph. Here I can set the correct SQL statement and the graph works fine.
Now I want the user to be able to input the WHERE part of the sql sentence. Can anyone point me to info or code on the web to do this ?
I have a site on which the visitor completes a form. When submitted, the form field details (email address, business, etc) are stored in an MS Access database.
I have to log-in to my server at the moment to see how many forms have been submitted.
Is there a way - I am sure there must be - of linking this MS Access database, that is, the number of forms submitted to it (which is not the same as counter 'hits', because people can visit the site without submitting the form), to an ASP/HTML page which displayes the figure in chart form month by month?
in my project, i want a label which shows the current value of all shares in the market whenever the user login to the application.how can i do that.how could i dynamically extract data from the shares website.
View Replies View Relatedi 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.
May I want to know ASP or Javascript can generate a chart (pie chart) ?
or other method can do that?
I have a fairly simple (at least in PHP) request but I can not find how do do it. I've seen things that are kindof what I want but not really. Here is what I want:
I have a ton of data in a DB. I want to pull some of that data and display it in a table. In PHP I would create a SQL query called $Result "(SELCT * FROM whatever)" and produce this code:
Is it possible to show different information on a page for different users?
For example a first year student that needs to select modules for this year compared to a second year student how would have to select different modules.
I've got an table that has event name, start date, end date. For instance:
EventID: 1
EventName: My Event
EventStartDate: 1/1/2007
EventEndDate: 1/4/2007
Right now we just display the name, start date through end date (if there's a different end date). So the above looks like:
My Event
1/1/2007 - 1/4/2007
Now instead, they want to have something like the following:
My Event 1/1/2007
My Event 1/2/2007
My Event 1/3/2007
My Event 1/4/2007
Other than trying to create some kind of math calculation based on the date, is there an easier
I would like to display the data in a table like first 50 records in a column and next 50 records in another columns.
View Replies View RelatedI have a client who is running a Windows Media Server where audio files are streamed with a ASX file. The client wants to display the most recent tracks played on a webpage.
The problem is, how can one find out what is the current track playing on Windows Media Server, so it can take the data and then insert it into a database which the webpage can just take it from there.
I'm using ASP to display data from an Access Database. My question revolves around the data and how it looks using CSS.
1) Do I have to use <p> in my access data to display paragraphs in my story.asp page? Without the <p> I just get one big chunk of data.
Which leads my to my other problem. When I do use <p> in my access data this code won't pick up my CSS class "body". I'm not sure why because I would think it would cascade.
<P class="body"> <%Response.Write (rs("newsBody"))%></P>
I have a page that allows users to sign on and then have access to the site. What I need to do is to have them sign on and see selected (tables) or data that is in the database.
I need some help. How would this be written. Unfortunalely the only book I have on the subject is asp.net. Code:
im currently working on a login system, and its the first time i have had to use an inner join. basically i have 2 tables, an attendance table and a member table. the attendance table contains the following: Code:
View Replies View RelatedI am trying to display a vaule from access (which is set to currency in access) as a currency (2 dp) on a web page. Here is the code: code:
Dim rsDB
Dim strSQL
Set rsDB = Server.CreateObject("ADODB.Recordset" )
strSQL = "SELECT ProductName, ProductPrice FROM Products WHERE ProductID=" & Request("ProductID" )
rsDB.Open strSQL, Application("strConn" )%>
<p><b>Product:</b> <%=rsDB("ProductName" )%></p>
<p><b>£</b><%=rsDB("ProductPrice" )%></p>
<% rsDB.Close %>
Should be easy enough, but I'm just starting out.
I have an ASP web page that displays records from SQL 2005 database. It works fine until I re-order the columns, all values of some columns disappear. I have no error or warning
I tried to change the font and font size, it doesn't effect.
Also I have an update record form, If I re-order the fields, some values disappear Code:
I am creating a dynamic website by using Dreamweaver 8 and Access as the database. I have designed the layout for the website and the database have also been completed. However, when I try to display the data on the webpage, it just won't display. I am also having some problems with the form and recordset.
View Replies View RelatedI am using MS-Access database to display top 10 records containg title and date, and with each record a text named "NEW" is also displaying.
But I want to display "NEW" only with the records which are not older than a week. Is there some way to calculate the present date with the date of each record?
I want to display data like the following:
<table>
<tr>
<td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td>
</tr>
<tr>
<td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td>
</tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
I want to be able to display my recordset as follows:
a e
b f
c g
d h
Instead of :
a b
c d
e f
g h
Any links to some examples?
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that?
How about 3 columns?
I have a drop down list which pulls Names from a column called 'Name' from an SQL Server view.
In this view is another column called 'ref' and each person has their own unique ref no.
I have linked a drop down list to the Name column (so user can pick name from the list) but now after selecting a particular name, I want my page to also display the corresponding ref for that particular name underneath.
The ref can be displayed just as text on the page.
I have an ASP/SQL 7 application that rips data from SQL Views onto an ASP
page. I have a money column in a SQL table that contains money income values.
When data is input to this field it needs to be displayed as money (to 2
decimal places - 10.00 or 7.60)
However, this only seems to be occurring when the user puts in the extra 0,
and if 7.6 is entered, it is still displayed as 7.6
I need all data to be displayed as money values (and it is selected as money
in SQL), so is there any way (either in the table design, View design, or
display on the ASP page) to get the data to 2 decimal places, no matter
what?
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI've got an application setup that uses freightquote.com API to receive XML responses containing shipping information. A basic response example is as follows: Code:
View Replies View RelatedI'm trying to display three columns in a table row, then I want to create a new row with three columns until there are no more records to display. Unfortunately, my code only displays one column in each row: Code:
View Replies View RelatedI am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
I am trying to display some DateTime data from a SQL Server db using the standard recordset object...objRec("PostTime").value
It displays nothing.
I used to have some static htm files which used to display data. There is a
calling asp file which used to do something like below
if Request.QueryString("PageName").count = 0 then
strPageNameHtm = "toc.htm"
strPageNameInc = "toc.inc"
else
strPageNameHtm = Request.QueryString("PageName") & ".htm"
strPageNameInc = Request.QueryString("PageName") & ".inc"
end if
strPageNameHtm = server.mapPath(strPageNameHtm)
strPageNameInc = server.mapPath(strPageNameInc)
'response.write(strPageNameHtm)
set fs = server.createobject("scripting.fileSystemObject")
set f = fs.openTextFile(strPageNameHtm)
strSPDHtml = f.readall
The strSPDHTML info used to be displayed using a response.write(strSPDHTML).
This allowed the static content to be loaded up.
I switched the static pages to be asp pages having the content come from a
database. I would still like to maintain the controlling page logic. Can I
modify the above section of code in anyways to access the asp page content