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:
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 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 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.
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.
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:
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?
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: