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?
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:
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
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.
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.
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?
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).
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
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?
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 ?
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?
Is there a simple function in ASP to calculate the dimensions of an image?
View Replies View RelatedWell 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:
I want to calculate the sum of all invoices so to be displayed total sum of them
I'm trying with this: Code:
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 Relatedi 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 RelatedHow do I calculate In ASP how many working days are there until a particular date?
View Replies View Relatedhow i can calculate yesterday date using asp?
View Replies View RelatedHow do I calculate the size of a folder? Also how do I count the number of images stored in a folder?
View Replies View Relatedhow do you calculate the time to run a script in ASP VB script ? Code:
<%
start_time = ???
'run script here
end_time = ???
%>
Has anyone seen a decent script for getting USPS rates live in your own shopping cart?
View Replies View Relatedi 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
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 RelatedHow to calculate the size of image, using ASP technology. Size means total pixel X pixel and total number of bytes.
View Replies View Relatedi 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 Relatedhow to calculate image size and number of kb used.
View Replies View RelatedAlright, 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 RelatedI 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)
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)
I have been looking around at various design solutions for uploading a file using ASP and have found that many sources have devised a much simpler plan using ASP.NET.
My question is this, I have a box running Win2k Advanced Server, with the .NET framework installed. WIll that enable me to run some of the new functions etc. decribed in ASP.net ??
What's the difference between ASP and ASP.Net? Which one should I learn in order to start making dynamic web pages for the internet?
View Replies View RelatedSo I need to write the difference between the biggest and the smallest number in database table. I know that I need to take MAX and MIN from table, but I just can't get it work.
Example:
Let's say max = 5 and min = 1, I need to have it like this:
5-1=4 (max-min=total)
Maybe my books are just sorry, but I can't find a description of what <%# is supposed to mean. I find Dreamweaver inserting it often.
View Replies View Related