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.
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 have a machine ftp-ing a file into a directory where a script picks it up and does something to it. I dont want the script to process the file if the file is still being copied.the only way I can figure out to do this is to check the size of the file... then wait 'n second and check the size again. and if the size is exactly the same... then asume its all there. but this doesn't seem like the right way to do it. is there no easy way or simple property I can check to see if its done?
View Replies View RelatedI've got a variable that can hold one or more words called strUserName. I want to display the complete value of that variable in a form field but I only get the first word
Agent:<input type="text name="agent" value=<% =strUserName %> size=30>
I searched this forum but couldn't find:
How can I retrieve the complete URL of the current page? (by using ASP, not Javascript!)
What I mean is this - I have a long URL something like:
https://www.zzzzzz.com:8080/zzzz/zzz.asp?aaa=1&bbb=2#a1
I know I can read parts of URL through server variables, such as PATH_INFO, QUERY_STRING etc. and then concate the string variable, but that is not enough! I need to request the COMPLETE URL like I mentioned in the example.
I need a function that would retain a value like 112.50 as opposed to 112.5. It is needed for currency values and display. I tried using cSng, cCur, but they all seem to trunicate the zero.
View Replies View RelatedHow can i delete a complete folder including subfolders
and files in the subfolders. Or do i to delete one by one
We are planning to improve the present search (Product DB search). Is there
any way on ASP script to make an auto complete text box, loaded with the
product names (like in google suggest). I hear AJAX, can that be used with
ASP scripts?
is this one possible with ASP?
"To complete your registration, click on the link below:
http://sub.domain.com/register.php?a...11&i=123456789 "
if this is, can someone please explain how to do it?
I've got a combo box with the values:
AAA
ABA
ACA
BAB
BBB
BCB
If I type the letter "A" it jumps to "AAA" in the list. If I type the letters "AB" it jumps to "BAB" as "B" was the last letter typed. Is there a way to have it accept "AB" as "AB" and jump to "ABA"?
I have problem with my page, but IIS only show "The page cannot be displayed". How to display complete error message ? I think I've read this sometimes ago here, but I can't find it.
View Replies View RelatedRight Im close to finishing this nightmare of a website now! 2 things left to do. First is insert images. OK I have done this using Shadow Wizards 'ShadowUploader'. So the way it works on my page is that the user has to upload the file from there local hard drive into the server folder.
Then they browse for that file, hit ok, then submit the form.
Can I restrict that browser window only to look in that Images folder on the server instead of being able to browse the whole computer?
is there a small command that resets a whole accessdatabase? I need a code that deletes all records in a database. Does anyone know how I can do this?
View Replies View RelatedI am trying to find ASP code so I can use auto-complete with a textbox by using ASP and Ajax. I can find asp.net and php, but no luck with asp.
View Replies View RelatedI have a requirement to record in a database when a file is finished
downloading to the end-user. Currently when a user clicks a download icon
for a file it directs to an ASP page that records the "hit" into a database,
then I use a response.redirect "filename.exe" to point the user to the
download.
What I'm missing is knowing when the download is complete so I
can update the database to show the file successfully completed its
download. Is there a way to do this with ASP? A way to do this with an
aftermarket component?
i ve a project to build a complete mailing site like hotmale or yahoo.i ve not any idea of doing this..i am a APS/PHP developer but this is a totally new project for me.so i d be thakful if some1 gives me the idea of whole setup...what kinda setup i ve to build.like Which Mailing Server (Exchange Server) and complete setup.its 'd be nice if soem1 send me any URL where i can find any tutotrial on this kinda solution.
View Replies View RelatedI have a simple asp form which writes to a csv.
The code it's based on (from "ASP for Dummies") is:
Set peoplefile - _
filesys.OpenTextFile( _
"c:inetpubwwwrootgbgbpeople.txt",1)
The form is going live soon, and I'd like just a dash of due diligence
in terms of security. I tried using a relative link to the gbpeople.txt
file which didn't work. Is there a better way around this without
reinventing?
I would like to know if it is possible to fill in an access table through a select list inside an APS 3 web page. If yes, how ?
View Replies View RelatedI 've coded an asp webpage where a user could toggle a boolean value through a checkbox.
When the checkbox was pressed, the page posted the toggle action to itself, a
connection.execute "UPDATE tableName SET fieldName=(Not fieldname) WHERE field_id=1
query was performed and the checkbox, after I had retrieved its new value through a recordset, changed its appearence(state). At first I used an MS Access DB and it worked fine.
After I had switched the hole application to work with MS-SQL, although I changed the above query to Code:
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?
View Replies View RelatedJust finished creating my own news script and was wondering if someone could look at it for me comment on it, how secure is it etc.
View Replies View RelatedI am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:
View Replies View RelatedI am facing a strange problem. I want to give a functionality to the client where he can download a complete folder from the server. but how to give this functionality is the main problem.
I have one ASP page where I am creating various files of vcf extension dynamically and now I want that client should be able to download all those files. Those files are present in one folder and so I want to give that whole folder to the client.so now I want some trickes/code or URL from you guys to achive 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.
Does anybody know of a script?
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 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
I have a list of data in a database(access). How can I get the total rows in the database?
View Replies View RelatedI 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?
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
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
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