Как отправить sql Update запрос в node.js?

Question

[Михаил Ярема]

callback срабатывает, а данные не обновляются

app.post('/update', (req, res) => {
  var sql = "UPDATE umodoc SET programmNumber = ?, fullName = ?, company = ?, personnelCategory = ?, subdivision = ?, position = ?, theoreticalTraining = ?, practicalTraining = ?, internship = ?, termOfTraining = ?, trainingInTheUTC = ?, trainingInTheUnit = ?, registrationDateOfTheProgram = ?, dateOfDelivery = ?, fullNameProgram = ?, link = ?, status = ? WHERE id = ?";
  var values = [
    [req.body.programmNumber,
     req.body.fullName,
     req.body.company,
     req.body.personnelCategory,
     req.body.subdivision,
     req.body.position,
     req.body.theoreticalTraining,
     req.body.practicalTraining,
     req.body.internship,
     req.body.termOfTraining,
     req.body.trainingInTheUTC,
     req.body.trainingInTheUnit,
     req.body.registrationDateOfTheProgram,
     req.body.dateOfDelivery,
     req.body.fullNameProgram,
     req.body.link,
     req.body.status,
     req.body.id
    ],
  ];

  connection.query(sql, [values], function(err, result) {
    console.log('Документ изменен');
  });
});

Comments

[Евгений]

У вас в массиве массив, либо

connection.query(sql, values[0], function(err, result) {
    console.log('Документ изменен');
  });

Либо

var values = [
     req.body.programmNumber,
     req.body.fullName,
     req.body.company,
     req.body.personnelCategory,
     req.body.subdivision,
     req.body.position,
     req.body.theoreticalTraining,
     req.body.practicalTraining,
     req.body.internship,
     req.body.termOfTraining,
     req.body.trainingInTheUTC,
     req.body.trainingInTheUnit,
     req.body.registrationDateOfTheProgram,
     req.body.dateOfDelivery,
     req.body.fullNameProgram,
     req.body.link,
     req.body.status,
     req.body.id
    ]
connection.query(sql, values, function(err, result) {
    if(err){console.log(err)}
    else{
     console.log(result); 
    }
    console.log('Документ изменен');
});