I am creating some questions site by ASP, by filling in the answers in a table on SQL 2005 and passing to the next site.
I'm giving the user a kind of tracking (identity), wich the user is passing over from on Question site to the other by Request.Form.
On the first Site the user is filling the name, first name, time and the kind of identity
sql= "INSERT INTO web(first name ,name,identy,time)VALUES('" & first name & "','" & name & "','" & identy & "','" & time & "')"
this works fine!
No I would like to continue with an Update Statement.
sql = Update web Set answer1='" & answer1 & "' where identity ='" & identity &
It gives me just an Internet Error Message: The page can't be shown...