SQL Update statement in ASP page
Posted on 2007-11-19
I'm currently trying to update a small database using a sql statement on an asp page. The line of code reads as follows:
"UPDATE tbl_Personal SET Email="request.form("email")" WHERE Username="request.cookies("MyCookie")("Username")""
This gives the error "expected end of statement". I'm guessing it's a syntax error as if I replace the line with the following:
"UPDATE tbl_Personal SET Emailemail@example.com' WHERE Username='John'"
...it works as expected and updates the record. I've tried various syntaxes and tried declaring the textbox value and cookie value as variables but I'm still stuck. Hope someone can help!