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 Emailfirstname.lastname@example.org' 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!