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?
i have a view cart page which shows remove an item and remove all item but i also wish to have add item function so i can add quantities for an item in the view cart page. i am not sure the right code for it. below is the remove item code.
if i wanna have an add item code, is there an amendment to do the code below . cos from what i see, its like u can do the opposite function for the code below to add items. Code:
need to subtract one date from another to show how long a user was logger in for. i.e.
<%=(rsDriverLogin.Fields.Item("OFF_DATE").Value)%> minus <%=(rsDriverLogin.Fields.Item("ON_DATE").Value)%>
The values in the sql OFF_DATE and ON_DATE fields are stored as 13/06/2006 19:01:28 . Can either be done on the ASP page or in the db itself, doesn't matter which.
I've tried lots of different ways to reach the total but failed every time. I want to subtract the retail price from the discount price using a fixed percentage. Is this possible?
I need to be able to do an SQL update on this table to subtract 1 from the product_quantity field.I could do this with two SQL queries (SELECT product_quantity, then subtract 1, then UPDATE table) but I'm sure there must be a way just to run one query which subtracts 1 from the field. how to do this?
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?
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.
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) %>
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:
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.
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
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
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.
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
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?
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?
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:
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.