Hi,

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?

/Robert