web form entry to access database w/asp

Hi swatson,

you have

first to:'Set up variables to receive the information from the form

Facility_id=Request.Form("Facility_id")
Facility_name=Request.Form("Facility_name")
Facility_description=Request.Form("Facility_description")
Street_address1=Request.Form("Street_address1")
Street_address2=Request.Form("Street_address2")
City=Request.Form("City")
State=Request.Form("State")
Zipcode=Request.Form("Zipcode")
Website=Request.Form("Website")
Image=Request.Form("Image")

after to:

sql_insert="insert into Facility (Facility_id, Facility_name, Facility_description, Street_address1, Street_address2, City, State, Zipcode, Website, Image) VALUES" & _
 "(Facility_id, Facility_name, Facility_description, Street_address1, Street_address2, City, State, Zipcode, Website, Image);"

It seem to me you r trying to insert empty variables. You must set up Variables before use them for anything, otherwise they are empty.

good look

Your variables need to be escaped from your string:

sql_insert = "INSERT INTO...... VALUES ('" & Facility_ID & "','" _
    & Facility_name & "','" &  Facility_description & .... )"

Whenever a database call fails you should ALWAYS check to see exactly *what* is being sent to the database.

You can do this by performing a:
Response.Write (sql_Insert)
Response.End
after you have built your string.

Cheers,
Andrew