473,686 Members | 2,167 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

results page

13 New Member
I designed a web form, which collects a little information from user (postal code, age, gender), and it goes to a mssql database on sql server express. I need to compare that input to rate tables on a .mdb database, which then I need to output the current rate, based on postal code, age, and gender.

I can't figure out how to compare the input values from the user to the rate data on the .mdb table

I'm using visual web developer 2005 express, using visual basic as the language. Does anyone know how I can get the current rate displayed on a web page, comparing the values users input to the .mdb tables?

Thank you.
Apr 7 '07 #1
3 1168
3,406 Recognized Expert Specialist
In what format is the data in the mdb file?

Apr 10 '07 #2
13 New Member
I'm not sure what you mean by format of the DB? I think I need to use query string to get the specific information out of the db. I'm just thinking this is too much for me. How do I hire someone to do it for me?
Apr 10 '07 #3
3,406 Recognized Expert Specialist
I'm not sure what you mean by format of the DB?
You said you were having trouble comparing the users inputed data to the database. The key to the solution is the format of the data in the database. that will determine how the query is written. For example a user enters a zip code, so you look up a zip code in the database and return the rate, right? If the "fromZip" field in the db is numeric, you could write the string this way:
Expand|Select|Wrap|Line Numbers
  1. query = "SELECT * FROM ratesTable WHERE fromZip = " & request.form("zip")
But if the "fromZip" field in the db is text, you need to add single quotes around the request.form data:
Expand|Select|Wrap|Line Numbers
  1. query = "SELECT * FROM ratesTable WHERE fromZip = '" & request.form("zip") & "'"
I think I need to use query string to get the specific information out of the db. I'm just thinking this is too much for me. How do I hire someone to do it for me?
The Scripts Developer Network has a job posting board where you could post for a contract job of setting up the db access how you want. I don't mean to discourage you from paying someone else (after all, that is the basis for a cooperative economy, right) but I learned ASP by tackling a similar question. You might want to check out a basic tutorial such as w3schools.com

Apr 11 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: NotGiven | last post by:
Say you have three pages, a search page, a results/master, and a detail page. You choose parameters on your search page and submit the page. The results show in the reults/master page. You click one to go the details page. You hit the browser button to go back and it shows the results/master page but shows "Page has expired" error. How can you prevent this? How can you show the results page whether you get
by: CharitiesOnline | last post by:
Hello, I have set this script up to add paging to a search results page. Which on the first page works fine. I calculates how many pages there should be depending on the number of results returned from my search and how many records I have set it to display per page. All great so far, HOWEVER..... When you click the next link to see the next 10 results on the next page, it just dumps the search details and pulls up all the records in the...
by: AbeR | last post by:
I have written a fairly simple reporting app that has been working for a few years without any issues until this past week. The application has a login page with a DSN lookup for login/password validation. A confirm login asp page does a redirect back to the login page if failed or to a menu page if passed where I pull information from the database into session variables that I pass throught the app for dynamic/individualized queries I...
by: George | last post by:
Hi, Anyone has the background for explaining? I have made a search on my name and I have got a link to another search engine. The link's title was the search phrase for the other search engine (a wicked phrase). Some but not all of the words of that phrase exist in my website. I reported it and they removed the link but did not give explanations.
by: Bigalan | last post by:
Hello, i am relatively new to PHP and i am struggling with printing multiple search results on to different pages. The code below works ok but when you click on next page button, it brings up a blank screen. I think it might have something to do with resetting the $found variable. Can you have a quick look? any suggestions would be greatly appreciated. <? if ($_GET) $vars=$_GET; else $vars=$_POST; $found = $vars;
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.