Updating a Table from a JAVAServlett

[Robert83]

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

[Armaron]

If I remember correctly, you only need to write "SET" only one time. So that would make:

state.executeUpdate("UPDATE TABLE presentation SET Names ='"+ name +"' , Pres ='"+ press +"', Musik ='"+ musik +"', City ='"+ city+"', Clubb='"+ club+"'");