querying access database

[Kris912]

I am trying to use an asp upload function. I am basing the image upload on the ID in the RS.

ID = upload.form("ID")
Title = replace(trim(Upload.form("Title")),"'","''")
EventDate = Upload.form("EventDate")
Description = replace(trim(Upload.form("Description")),"'","''")
Notes = replace(trim(Upload.form("Notes")),"'","''")


Does it make sense to query it this way and is this the proper syntax?

sql = "select ID from Events where ID= " & ID

ID is a hidden field in my form so is it being passed correctly?

I originally was querying the database this way:

sql = "select ID from Events where Title='" & Title & "'"
set rs = connection.execute(sql)

I don't get any error messages this way and it makes sense to me that it would pull the correct ID but it isn't uploading the pics. Please look at thread 333-1111650 for the full code I posted yesterday.

Thanks for all your help!