Calculate Max Value Of Y Axis
I am using a javascript function to draw a graph on my page, which all works fine. One of the parameters that I pass to the javascript function is the maximum value of the x and y axes.
I have encountered a problem, in that if I hardcode the maximum value of the y axis to 1000, and the maximum value that I am plotting is very low, eg 10, the bar is so small it can hardly be seen. It would be better in this case if the maximum y value was something like 15 to ensure that the bar went almost to the top of the grid.
The code which is doing the count is a simple loop which is looping through each of the months in the financial year counting the number of meetins which have occured in each month. Code:
View Replies
ADVERTISEMENT
I prepare a owc chart in asp.
in category axis (x-axis) i want to adjust date format according to date range, For Example: if data is of 5 years then tick lables show Years as below
Large data : 2005,2006
Medium : Jan, Feb
Samll : Mon, Tue
I've tried by NumberFormat property
Chartspace.Charts(0).Axes(0).NumberFormat = "dd,mm,yy"
but it is not working.
can it be done through ASP or via SQL statement. if SQL then how
View Replies
View Related
What is a straightforward way to generate a simple line
graph from provided x-y data points in an ASP script.
View Replies
View Related
Our store software currently displays the total amount saved (the list price minus our price) for every product using the code below:
'Calculate "YouSave"
If Product_ListPrice > 0 Then
Product_YouSave = Product_ListPrice - Product_LowestPrice
End If
I, however, would like to also diplay the percentage saved next to the amount saved. I tried using the code below but it won't work. Can someone help me out?
'Calculate "YouSavePercent"
If Product_ListPrice > 0 Then
Product_YouSavePercent = ((1 - (Product_LowestPrice / Product_ListPrice) * 100)
End If
View Replies
View Related
I am building a database that users will update.
I have a table named "products".
Every product has a shelf life of 3 years and expires exactely at the end of the 3rd year.
Here is my table:
Productid ---- int
productName ---- varchar
manufacture_date ----- datetime default (getdate)
Expire_date ----- datetime
What I want is this, whenever a product is entered, the defualt date is the date the entry
was made. (I am using the "getdate") to automatically grab this.
BUT I also want the "Expire_date" field automatically calculated and then filled in.
That is, a user enters a product "manufacture_date" as 05/22/2003,
Then I want the expire field to be filled with 05/22/2006.
My preference is to handle this on the DB site and not ASP.
View Replies
View Related
How to take values from a query and add them together to get totals.The current setup I have:
User selects home they want and clicks on link that passes variable (model home #) that takes them to page 2.
Value in query string is taken and used to bring information about home such as base price amongst other things.
What I would like to do is start with home base price and then call upon options stored in database(each option has their own price)and user can go down a list and select the options(via checkboxes)they want and then at bottom they have a total button that totals base price of home and each option they chose.
View Replies
View Related
if it's possible to do what follows:
i'm getting from querystring *, /, - or + like ...&calculate=* now i want to use this in the calculation like var1 calculate var2 . how do i get it to understand that it's not a string but an actual calculation?
View Replies
View Related
I have a table named tblsheets (access 2000), There are 4 fields I'm concerned about.
Size, Material Grade, Module and Weight.
I wanted to be able to give the user the ability to calculate the
sum of weight according to a specific material grade and specific size in a specific module.
How would I go about creating an asp script that will allow me to do so?
There has to be an option in which the user can select from a combo box the module, and then select material grade and size, also from a combobox if possible (getting the data from tblsheets).
View Replies
View Related
I have a problem to calculate the day different. I use
datediff(currentdate, quoteDate) > 20
The error message is : Wrong number of arguments or invalid property
assignment: 'datediff'
I use datediff("D", Date, quoteDate) > 20, but still could get the correct one. Maybe I need to change string to the digit. How to do it?
View Replies
View Related
need to do a simple form calculation in asp based on values in 2 other field and enter that data into table.
(field)SubTotal + (field)VAT = (Result in field)GrandTotal
View Replies
View Related
I have been asked to create an ASP page that calculates a variety of tariffs,i currently have a an excel document which allows users to input the data and then when pressing the auto sum the other spreadsheets update.
Is there away of linking an asp page to the excel document to input the user data, and then to display the results on the next page?
View Replies
View Related
I need to display 3 fields with future dates (Fridays only) as table
column headers.
i.e. 16th Feb | 23rd Feb | 2nd March.
As each week passes, i.e. from the Saturday, the dates should move
accross 1, i.e. column 1 will update to 23rd Feb, Column 2 to 2nd
March and Column 3 to 9th March.
23rd Feb | 2nd March. | 9th March
I need this to work in IE & Firefox specifically.
Please can you help me work this out ?
View Replies
View Related
I am trying to calculate (in minutes) the difference between two times. In the database the times are in this format:
Start Time (Game_Time): 1/1/1900 12:00:00 PM
End Time (GameEndTime): 1/1/1900 1:00:00 PM
Here is the code I'm trying:
Code:
GameLength = DateDiff("n",Game_Time,GameEndTime)
The result is: 780
I would expect it to be: 60 minutes
What am I doing wrong?
View Replies
View Related
Is there a simple function in ASP to calculate the dimensions of an image?
View Replies
View Related
Well my goal is simple. On my site we show "You save: $**.**" but I want that to say "You save: $**.** (**%)."
The database for our store stores the list price, and our price. The store calculates the you save price... so it should be easy to calculate the saved percentage as well. Here's the code that calculates up the "You save" currently on our website: Code:
View Replies
View Related
I want to calculate the sum of all invoices so to be displayed total sum of them
I'm trying with this: Code:
View Replies
View Related
I this problem is serious for me because my job depends of it. Maybe my problem is so obvius and easy to solve but I don't know what is the problem. I need to do a program that will calculate an interest rate done it in ASP. It should be made as a page that will have an action in the same page. The rate percent is given into the database and i can not take it from there in order to calculate and display the result. Here is my code: ....
View Replies
View Related
i am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
View Replies
View Related
How do I calculate In ASP how many working days are there until a particular date?
View Replies
View Related
how i can calculate yesterday date using asp?
View Replies
View Related
How do I calculate the size of a folder? Also how do I count the number of images stored in a folder?
View Replies
View Related
how do you calculate the time to run a script in ASP VB script ? Code:
<%
start_time = ???
'run script here
end_time = ???
%>
View Replies
View Related
Has anyone seen a decent script for getting USPS rates live in your own shopping cart?
View Replies
View Related
i have some problem in showing data. I have two tables . First table(containing Hosting categories). Second table(Containg catagories data like l,keyword,description.....etc). I want to display catgories names from first table and then diffrent catagories total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
:
:
:
etc
View Replies
View Related
i need some help with my asp project. there few text field . for user to enter in amount. and i need the system to auto calculate the total everytime user finish enter amount in a text field. another problem is how can i make the text field accept number only?
View Replies
View Related
How to calculate the size of image, using ASP technology. Size means total pixel X pixel and total number of bytes.
View Replies
View Related
i am developing a hosting directory web site on this site there will be the links of hosting websites, i want that when user click on a particular website link it will be recorded in the database how it could be done.
View Replies
View Related
how to calculate image size and number of kb used.
View Replies
View Related
Alright, in regards to my previous post of finding a DB that has all of the latitude/longitudes in a DB, I need to now filter through those based on search criteria. The search criteria available includes: Code:
View Replies
View Related
I need to calculate a total based on fields in a repeat region, these values are stored in an SQL db, all are numeric and written in ASP.fields are
TOTAL_COST VAT GRANDTOTAL (Page selects records based on
field parameter and displays in a repeat region)
At bottom of page need to show total sum like
TOTAL_COST(sum of above)
VAT(sum of above)
GRANDTOTAL(sum of above)
View Replies
View Related
i have some problem in showing data. I have two tables
First table(containing Hosting categories)
Second table(Containg catagories data lik
url,keyword,description.....etc)
I want to display catgories names from first table and then diffrent catagories
total records from second table, like this
ASP.NETHosting(10)
Linux Hosting(20)
Windows hosting(13)
View Replies
View Related
I have an Elapsed time column in my database. This is stored as a varchar. I would like to be able to calculate these values and place on my asp page.
Below is an example of a value in my database:
2:00:49
This is 2 hours and 49 seconds. I would like the return value to be in Hours:Minutes:Seconds
Any ideas?
View Replies
View Related
I would like to know how we can calculate the number of days OR number of months between 2 dates in ASP.
If you someone have some suggestions or can provide me some exmaple code, that will be a great help.
View Replies
View Related
