Getting Total Price
I am trying to add the price and shipping to equal the total price and display it in a table(receipt) I am able to get the price and shipping and handling to write to the page, but not sure how to add them together to get the total price:
The below code gives me $40.00$ 3.00 I want it to show as $43.00 ($40 + $3.00)if they ordered 500 business cards or $75.00 ($72 + $3.00)if they ordered 100 business cards.
<%
quantity = Request.QueryString("quantity")
If (quantity = "500") Then
price = "$40.00"
Else
price = "$72.00"
End If
%>
<%
shipping = "$ 3.00"
total = (price + shipping)
%>
View Replies
ADVERTISEMENT
I've just launched a web site that sells collectibles. To do this I've got a ASP shopping cart with a checkout process.
As all the prices on my site are in Australian Dollars, I' trying my very best to find a way to display the total price in USD as well....
Eg:
Total Price : $ AUD 100.00
Total Price : $ USD 79.00 (real time rates)
I need to do this because I also want to Accept PAYPAL account payments which cannot be made in AUD.
View Replies
View Related
i have 3 textfields: txtPrice, txtQty and txtSubPrice.
price for an item will be fetched from db at display in the txtPrice (i can do this). then, user just key-in the quantity for the item and automatically the sub price will appear in the txtSubPrice.
i have coded a function name CalculateSub() using javascript and tried to do the automatically calculation using onClick and onFocus at the txtSubPrice but failed. seems like textfield cannot has this function.
View Replies
View Related
I have a search form which has a price drop down menu with diferent values.
In this list there is an option "Any price" its value is "%" and the results page its retrivig a full list of items with any price.
Waht I want to do is that if you select 150.000 from the list, the results page should retrive items from 150.000.
View Replies
View Related
Does anyone know of a quick and easy way to stream a particular share price
eg: msft into one's website....I have done a google search but I am not
finding anthing specific...is there an asp solution?
View Replies
View Related
Using classic ASP, are there any examples which I can use to show a stock price of a particular stock.The URL I am looking at is:
http://quote.yahoo.com/q?s=MSFT
Is there a way that the page will directly update the intranet page with the stock price of the indicated stock?
View Replies
View Related
I need to use excel price function in asp.How can I use below formula ina asp.
PRICE(settlement,maturity,rate,yld,redemption,freq uency,basis)
Pls check the attachment below.I don't know how to apply this kind of formula in vbscript.
View Replies
View Related
how i can have a fixed 2 decimal space for price of an item.i have the code shown below but the result shows more than 2 decimal space or even 1 space. Code:
<%=formatnumber(rsProdInfo("Unit_Price"))*(GST)+ formatnumber(rsProdInfo("Unit_Price"))%> ...
View Replies
View Related
I have looked all over the net and even down the back of the sofa but I've been unable to find any scripts that allow me to add price comparison functionality to my shopping cart. where a script might be or even offer some pointers as to how I might go about doing this.
View Replies
View Related
Does anyone know an easy way to put a current gold price on your own website? I've seen the graphic methods that Kitco.com offers, but I'd rather have it pull the value from some gold market system in text format. Code:
View Replies
View Related
I have been asked to design a page where users login.
The users list is accessable from a drop down list which is taken from an SQL server table
The user, when selected then click next to login to a page where their name, associated with thier username is displayed.
Now I am a total newbie to this, can anyone guide me in the right direction?
View Replies
View Related
Im trying to figure out how i can do the following:
I used a search script to select data from the database now each record has a figure such eg. £125.56 and so you can end up with rows like:
£125.56
£12.34
£.456.76
What I want to be able to do is have a select box to the right hand side where you select certain records and if possible at the bottom will have a live update showing the total of the selected items.
Does anybody know of a script?
View Replies
View Related
I have an asp page that gives records that shows number of days like so:
<% Days = RSItin("Depart") - RSItin("Arrive")%>
<% response.write days %> days
How do I get the total number of days - ie:
Record 1 2 days
Record 2 4 days
TOTAL 6 days
View Replies
View Related
I have a list of data in a database(access). How can I get the total rows in the database?
View Replies
View Related
I have a column which i store my totals (price) and i want to sort the records by total.
simple way of ordering as ORDER BY doesn't give correct solution since it sort according to the first number. like this:
1
24465
27184654
i want to sort it like
27184654
24465
1
do you know how?
View Replies
View Related
I have a script that writes out a report to a webpage with data pulled from a mssql database.
I am trying to figure out how to keep a running total for one of the columns of data.
For example, in the users column, if Steve Smith appears 172 times, I want to have a total at the bottom of the report that says:
Steve Smith : 172
Debbie Brown: 100
Brian Katich: 42
etc
View Replies
View Related
Any one have any suggestions on the best to add up the values of a certain fields that
are displayed in a table, like below:
Hours Actual Annual Sick Compassionate Other Reason
8 0 8 0 0 0 leave
8 0 0 8 0 0 flu
--------------------------------------------------------------------------------
16 0 8 8 0 0
View Replies
View Related
I have an web application that allows a user to order items online. The user selects an item from a list on the order items page and enters the quantity. The quantity and unit price of the item is calculated on the order summary page. And than on the process order page, the calculated total from the order summary page is represented as the extended total for that item.
My problem is when that same user in a single user session orders another item, the extended total for the second item is not being added to the extended total of the first item. In other words, I would like to know the code to keep a running total for this user. I keep getting only the extended total for the current item exclusive of the previous item in that user session.
View Replies
View Related
I need to be able to subtract the total quantity of a product when someone places an order. I'm trying to get my head around this; what's the strategy for doing something like this?
ASP SQL
So let's say I have a "Thank You" page at the end of the purchase. I have a table with a list of product Ids and a column of quantities left.
If I understand your post, I'm picturing this being a stored procedure that looks at the total quantities from my table that contains all the product quantities. Let's say product 1a has a quantity of 5 and product 2a has a quantity of 6.
A bit fuzzy here but what would a stored procedure look like that is able to update and step through all the items that were purchased?
View Replies
View Related
I am using a select sum(tot_daily) as total hours ...it calculates the time incorretly...
Example:
ID | Tot_hrs | Person
----------------------
1 5.45 A
2 5.45 A
3 5.45 A
The total hours should be 17 hours 15 mins...but the result comes as 16.35.... Is there a way to calculate it as 17.15 in db level in a select statement
View Replies
View Related
i have a small issue with displaying total
heres what i need to do
if its 11 * 7 =77
i need to print 77.00
if its 7.95 * 3 =23.85 then its right
so when its whole number i want to put a .00
is this possible
here is my code for it
Code:
View Replies
View Related
i dont know if this should be a mysql question or a asp question...
i have a database that stores all the orders and each orders total. How can i make it so that i can add all the order totals together, to get a final total
Im using mysql.
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
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 can i get a total number of filtered records? what's the code?
View Replies
View Related
tell me the syntax for adding string numbers together to give a total? Code:
strNumber1 = 4
strNumber2 = 2
strTotal = strNumber1 + strNumber2
The above code gives the result 4+2
If I change the strtotal to strNumber1 * strNumber2 it gives the result 8
If I change the strtotal to strNumber1 / strNumber2 it gives the result 2
If I change the strtotal to strNumber1 - strNumber2 it gives the result 2
So what do I use to get it to add the numbers together .
View Replies
View Related
I am creating a simple one page blogger for page visitors to 'rant' so to speak... This is a remake of the old one and I've got about 49 pages of 5 entries each from the old one.
I need to make different dynamic pages using querystrings in the url which is simple enough. The page numbers are dynamic based upon totall records in the 'rants' table divided by 5 entries per page. Previously I've used a 'for next' statement nested in an 'if then' to actually go throuch each record and count it but it taxes the server while proccessing other parts of the page.
is there a SQL command that I can use for my ODBC connection to get the total number or rows in the 'rants' table?
View Replies
View Related
is any on eone out there who can help me with my asp script. upto now i have managed create my database using MSaccess and connected my database to the web server. Code:
View Replies
View Related
I want to do a running total query , here is what i want :
I want the running total like this:
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
I have y pic's on the server and each time someone visits the site I want to display x of them randomly.
View Replies
View Related
I want to display something strictly if the value of pid = 4, except anything after this, for example index.asp?pid=4&nid=3.
Still the if statement continues to display I am sure because pid=4 still exists is there a method to be strict, for example not & ....
View Replies
View Related