Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    ASP






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Subtract The Total Quantity


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 Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Add Quantity For Item
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:


View Replies !   View Related
Update Quantity In Shopping Cart
I have to modify an existing shopping cart to allow the customer to update the quantity (backend is SQL 2000).

I believe I have a good idea how to go about it but would like to read some examples or advice.

View Replies !   View Related
How To Count The View, Donwload, User Quantity?
i saw from the web, how can the coding write out to count:

1. how many people View this image?how many people View this Topic?

2. how many people download that image, software or etc?

3. how to write out the code?

View Replies !   View Related
Subtract 2 Dates
i need to subtract today's date from another data in the future to tell me how many days left for this data

i tried this
Code:
dim a
a=1/8/2003
dim b
b=date()
dim c
c=a-b
response.write c
but it gives this
29/06/1796 05:15:26

so can any body tell me how can i do it ?images/smilies/confused.gif

View Replies !   View Related
Subtract One Datetime From Another
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.

View Replies !   View Related
Subtract Time
Do u know how to subtract 2 times in this format ?

'03:20 PM' and '03:45 AM' , the result should be 12.25 mins.

View Replies !   View Related
Subtract Percentage
I would like to subtract a fixed percentage (15%) but can't seem to get the syntax right.

Output:
Item: Nougat Retail Price: $3.99 Discount Price: 15% Total: ?

Code:
strChocoItem1 = "Nougat"
strRetPrice1 = FormatCurrency("3.99")
strDiscPrice = FormatPercent(".15")
strTotal = ?

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?

View Replies !   View Related
Subtract Days From A Date
I am trying to subtract days from a date but I didnt got it. how to do it?

View Replies !   View Related
Subtract 1 From A Table Field
I have a product table in Access, like this:

product_id | product_name | product_quantity

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?

View Replies !   View Related
Total
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
Total Sum
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
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 !   View Related
Get Total Value Of A String
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
Get Total Rows
I have a list of data in a database(access). How can I get the total rows in the database?

View Replies !   View Related
Sort By Total
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
Total Function
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
Total Value Of Field
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
Order Total
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
Total Weekly Hours
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
Display Total Problem
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
Complete Order Total
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
Calculate Total Number
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
Calculate Total Records
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
Auto Calculate Total
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
Get Total Number Of Records
how can i get a total number of filtered records? what's the code?

View Replies !   View Related
Add Str Numbers To Give A Total
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
Counting Total Rows
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
Asp Request For Total Dummy
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
Running Total In Access Query Or Asp
I want to do a running total query , here is what i want :

I want the running total like this:

View Replies !   View Related
How Can Calculate Total Number Of Hits
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
Display X Random Pics Out Of Y Total
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
Total Restrict In My If Statement, Not Take Into Account &?
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
Calculate Total In Repeat Region
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
Calculate Total Records Count
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
Total File Size Per Directory
I used to have a little ASP file (classical ASP) that would show me the total file size used per directory. I didn't need it for many years and now that I do I seem to have lost it.

Does anyone have an classical ASP file/script that will loop through your filesystem and shows the total Mb's used per directory? I could write it myself I'm sure, but if someone has a script like this ready it would save me quite some time.

View Replies !   View Related
Sum Form Fields Add Total To Database!
I have a an issue that I would love to solve. The below code adds 111111111111111111 to the field when I want it to sum the amount which in this case totals 18 and then add that total (18) to the field! Code:

View Replies !   View Related
Display Total Records From Command Object
i'm using command object like this:
objCommand.CommandText = strSQL

strSQL being a SELECT string.

then executing it:
Set rsRec = objCommand.Execute

how can i get total number of records found, changing the line above to this:
Set rsRec = objCommand.Execute totRec

gives me an error and doing just this:
totRec = rsRec.RecordCount ....outputs -1

View Replies !   View Related
Calculate Total Money To Nearest Penny
how to write a function to calculate total amount to nearest penny in ASP using VBSCRIPT.

View Replies !   View Related
I Just Spent Several Hours Shaving A Total Of 250 Milliseconds Off My Application
building variable width/DB tables etc using getrows instead of movenext.
Performance is a major concern as this app requires SSL.

My question is, when does it become more about the challenge of building
faster apps vs. getting the job done??? If my calculations are correct, I
just added an extra 10,000+ possible hits within a 12 hour day or so.. an
extra 10,000 hits???!!! What percentage of applications do you think will
ever see this kind of traffic?

Is this insane? If this app ever gets maxed out, will my end users ever
realistically notice a difference?

View Replies !   View Related
I Am Having Problems With Calculating The Total Seconds From Two Date/times.
I need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".

Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code:

View Replies !   View Related
Total Price In Other Currency (Real Time Rate)
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
Forum Menu - Total No. Of Views(for Specific Topic)
every time a user clicks on a record its noViews is updated, and similarly the noReplies is incremented by 1 if there is a reply to a record(question). Code:

View Replies !   View Related
Display Records From MS Access Tables As A Total In A Table In A ASP Page
I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)

Joe Bloggs ---> 100 Closed

Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved