You may simply use AJAX to do the calculation without submitting the form
Try searching for AJAX with google
Good luck
Regards
Raj
Main Topics
Browse All Topics
Loading Advertisement...
Question
ASP form calculation
Hey Experts!! I hope everyone is having a great holiday weekend.
I have an intranet built on an Access 2003 database and classic ASP. I have been recently been asked to bulid a budgeting system. It consists of something like this:
The accessory table contains the pricing, while the other tables contain the client information as well as the product. The client can have more than one product. However, each product's pricing is set inside the table. So one client could have like 3 products with 3 different accessories. I need to be able to do a budget for up to the next 3 years for one client.
Bottom Line: 1 Client has 3 products with 3 different accessories. I need to do a budget for up to the next 3 years with all 3 products(no pricing) with all 3 accessories per prodcut.
I need to be able to have a form, filled out by the user for quantity and then multiplied by the price to give a total.
I hope I've explained that correctly. I just have NO idea where to start. Nor do I know how to do ASP calculations.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Subscribe now for full access to Experts Exchange and get
Instant Access to this Solution
- Plus...
- 30 Day FREE access, no risk, no obligation
- Collaborate with the world's top tech experts
- Unlimited access to our exclusive solution database
- Never be left without tech help again
Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.
- "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
- "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
- "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.
See what Experts Exchange can do for you.
Got a question?
We've got the answer.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
Need individual assistance?
Our experts are ready to help.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Want to learn from the best?
Read articles from industry experts.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Working on a long term project?
Store your work and research.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Trusted by the world's most respected brands.
Faithfully serving IT professionals since 1996.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Free Tech Articles
-
WARNING: 5 Reasons why you should NEVER fix a computer for free.
It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
-
SCCM OSD Basic troubleshooting
SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
-
Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
-
Create a Win7 Gadget
This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
-
Outlook continually prompting for username and password
There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
-
Backup Exchange 2010 Information Store using Windows Backup
There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...
Cloud Class Webinars
- Avoiding Bugs in Microsoft Access
Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
- Top 10 Best New Features in Visio 2010
Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
- IT Consultant Business Secrets Revealed
Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
- Disaster Recovery and Business Continuity
Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
- Organize Your Visio Diagrams with Containers and Lists
Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
- How to Us Objects, Properties, Events and Methods in Microsoft Access
Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Answers
I can provide info and details on AJAX if that is needed but you don't need it if you already planned to submit the form. Please clarify exactly what you need but researching AJAX could be a distraction if I read your question correctly. There are lots of ways to caculate and work with forms and database tables without needing AJAX.
bol
@ b0lsc0tt:
I do apologize for my rambling and complexity of the question. I was looking into AJAX but only found one tutorial(http://www.mikesd
Ultimately, what will happen is the user chooses a client, from there they will go to the budget. From there, they choose quantities (and possibly a discount option) and the number of years. Then boom, it gives them an outlook for the next x amount of years.
Is that a little more understandable? I hope so. :)
Thanks for the response. I do understand what the project entails. I am just not sure exactly what you are asking for here. Keep in mind what I said about project in my first response. What code do you have? What step in this project do you need help with now and in this question?
As far as AJAX goes when the users chooses the client they go to a budget, right? That is on a new page or do you want the page to stay the same? THAT is the key to whether you will need AJAX. From what you said it seems you plan to submit the page when the choose a client and show a new page for what is basically step two. You don't need AJAX for that. There are a lot of great sites for AJAX info, including one of my favorites that even uses ASP (Classic) for the server code. A search of this site's knowledge base for comments by me and words ASP and AJAX should show them to you. You could even open a new question if you want help using or learning AJAX but it doesn't seem like something you need for this project.
Sorry I haven't been able to be specific with the help yet. Let me know if you have a question about this or the general info I provided. If this is something you need all done for you then an EE question won't be the way to get it.
bol
I see what your saying b0lsc0tt. I see that my question is a little confusion. I do apologize for the extended and unnecessary wording. Let's start with this then:
Ultimately, I would like to submit the form because it will ultimately be exported to Excel or PDF.
So how can I perform calculations in classic ASP?
I think this would be best, but I'm not entirely sure. Suggestions?
ASP can handle math calculations with the same math functions that are available to vbscript. There is a good list with simple explanations at http://www.w3schools.com/V
iNum = 5 +3 ' iNum will be 8
iNum = 5 * 3 ' iNum will be 15
Let me know if you have any other questions about caculating in ASP. If you need help with a specific calculation or having problems with a specific one then please provide details.
bol
You still aren't being very specific it seems. Hopefully I have understood you correctly but let me know if it doesn't seem right or give the result you expect. You will need to be more specific on the calculation you need if that is the case.
The snippet below has the code I believe you need. It will mutliply the 3 variables by their prices and add the results. Let me know if you have a question about this or how it works.
bol
I am sorry for badly worded questions. I do appreciate EVERYTHING your helping me with. Let me see if I can explain this now.
I have a form that contains the the named form fields above. These I'm pretty sure are the variables. What I need to do is pass those(as the user submits the form) into the formula that you gave above.
I think the proper question here is, how do you pass user declared variables into an ASP calculation? I have declared the variables. But I want to be able to have the quantities put into the formula(calculation).
Thanks! Your ASP code can get the values from the form fields by using either Request.Form("FIELDNAME") or Request.Querystring("FIELD
Don't forget to validate the form input. You put the value in an ASP variable but should then validate it before trying to use it. In this case since you expect numbers you would check to make sure the input from the form is a number and the type of number you expect. Just a side note or caution but something you should always do. :)
bol
b0lsc0tt you've been very awesome so far. Thanks for everything.
I'll have to get the code later this evening when I get to that PC. I'm off-site right now.
I read what you wrote and it makes sense now. I know the page starts out by declaring my variables like the code below.
How can I get the value of a different recordset inside of that formula? Or should I put this formula inside of the same recordset that pulls all of the data?
I am glad that made sense and helped.
The code in the snippet doesn't mention a recordset so I am not sure what you refer to by "different recordset." The code (or formula) in the snippet just needs to go where you need it. From your earlier post it seems those "qty_" variables and "total" were meant to have info from the form. If that will go in to a database table then you might have the formula (or code above) in the recordset code or right before it. It might even be after. It all matters on the order of the code and its logic. There is no way I can be more specific but hopefully this explanation helps you know how to use it. Just remember the variables only last as long as the script runs and the recordset is something that is opened and closed by the script. You can't do anything with it before or after it is opened/closed.
bol
Here is the entire page of code:
As you can see starting in line 4 is where I want to declare the script and the formulas.
On line 97 I have another recordset that queries all the info I want/need.
Can I put those recordset variables (rs_contact) into my script? Would I have to move my script down the line just after the recordset to achieve this?
The lines in the snippets seem off from what you mention in the response (e.g. line 97 has nothing but ASP open tags). With ~400 lines and since it is DW code it is not easy to get a quick idea of all that is going on.
I did see the recordset called rs_contact. Where in the "script" did you want to use its variables? You will only be able to use them while they exist so if you need that info earlier in the script then you must create the recordset earlier (or twice). If you need the code you have in lines 4-7 (the "script") in the snippet above in the rs_contact area (the "recordset") then you just need to make sure the script is not below the recordset. It could be fine right where it is unless it needs to use info from the recordset. If that is the case it will need to be in the section after rs_contact is made into a recordset.
Does that make sense? Let me know if anything isn't clear or you have a question.
bol
p.s. The lines 4-7, i.e. the "script", needs to have the variable's values set somewhere. If you still need help on this then please clarify if those values come from the form that is submitted or a recordset.
What parts or where are the "calculator" or "user" variables? I think "calculator" is the lines that were in 4-7 in the recent snippet but please confirm or clarify.
Have you moved them somewhere to see what result you get? Did you understand what I meant when I said (a few times I think) the variables have to be defined either before or when you use them? Did you put your formula in the rs_contact recordset? What was the result?
bol
The calculator is lines 4-7. I haven't moved it yet, but what I was thinking was moving into the rs_contact recordset. I think I would put them at the very beginning of the recordset. Right??
But how would I call other fields in that same recordset to interact with that formula?
Unfortunately I won't have any code until maybe tomorrow.
Try what I have already suggested to see how it works and the results you get. Whether you place it in the loop for the recordset, just above that code, or somewhere else usually depends on the result you want (as I have said above). If you aren't sure how it works then try one and the results usually make it clear. If you have a question about using what we have said or its results then let us know and be specific and detailed.
I have no idea what you mean by "other fields" but remember I gave the general information in an earlier comment on how to get form fields. That comment is at http:#a24795127 . It has the info you need to get any value from a submitted form.
Let us know if you have any other questions about what we have said to answer your question here. Remember if other questions come up with this project then it is best to open a new EE question for those.
bol
Ok, did what you said and it works great!! Only problem now is if the page has multiple instances of a product, the total of the first product will go into the total of all the other products even if there isn't a number in the other fields. I am going to open another question.
Just wanted to say thanks for teaching me something new!!
3 Ways to Join
Business Accounts
- Perfect for organizations
- Multiple users
- Save over 36%
- Create a Business Account
Answer for Membership
- Earn free access
- Showcase your knowledge
- No credit card required
- Sign Up to Answer
Loading Advertisement...
by: b0lsc0ttPosted on 2009-07-02 at 20:30:29ID: 24769616
LZ1,
This won't just be a basic answer if you want all of that. Also to provide info on queries you would use we need details on the fields in each table and any relationships between the tables. If that is all you are really asking for help with then please provide those details. However if you also need the form page made and the report page then will you be doing the main work yourself and just need help with specific issues? Or is this a project you need all done for you? If the latter then it will be best done by hiring a developer in my opinion. If you do just need help with a specific thing and are working on this yourself then please clarify what you need here.
It does sound like an interesting project. Let me know if you have any questions or need more information.
b0lsc0tt