472,342 Members | 1,429 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

results page

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 1128
3,406 Expert 2GB
In what format is the data in the mdb file?

Apr 10 '07 #2
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 Expert 2GB
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...
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...
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...
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...
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...
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: CD Tom | last post by:
This only shows up in access runtime. When a user select a report from my report menu when they close the report they get a menu I've called Add-ins...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: antdb | last post by:
Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

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.