Updating a Table from a JAVAServlett
I have some problems with the syntax in my SQL UPDATE statement, it looks like this;
state.executeUpdate("UPDATE TABLE presentation SET Names ='"+ name +"' , SET Pres ='"+ press +"', SET Musik ='"+ musik +"', SET City ='"+ city+"', SET Clubb='"+ club+"'");
I have tried many variations with " " and ' "
Only when I try and run my servlet I get the following exception:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
My question is: how should the SQL syntax look olike in my SQL statement?