ola galera nao estou achando o erro meu codigo e ele esta retornando erro de syntax no sql
grato
[code]
String sql= “update cad_cliente set (razao =?,fantasia=?,cnpj=?,endereco=?,nun=?,bairro=?,uf=?,cidade=?,cep=?,resp=?,tel1=?,tel2=?,fax=?,id=?,site=?,mail=?,sla=?) where fantasia = ?”;
int int_id=0;
int_id=Integer.parseInt(id);
try
{
theConn = MyConnection.getConnection();
PreparedStatement ps = MyConnection.getConnection().prepareStatement(sql);
ps.setString(1, raz);
ps.setString(2, fantasia);
ps.setString(3, cnpj);
ps.setString(4, end);
ps.setString(5, num);
ps.setString(6, bairro);
ps.setString(7, uf);
ps.setString(8, cidade);
ps.setString(9, cep);
ps.setString(10, resp);
ps.setString(11, tel1);
ps.setString(12, tel2);
ps.setString(13, fax);
ps.setInt(14, int_id);
ps.setString(15, site);
ps.setString(16, mail);
ps.setInt(17, sla);
ps.setString(18, fantasia);
ps.executeUpdate();
ps.close(); [/code]