results page

[mlg74]

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.

[jhardman]

In what format is the data in the mdb file?

Jared

[mlg74]

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?

[jhardman]

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:

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:

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

Jared