M
M
Mikhail Yarema2017-10-27 11:33:18
JavaScript
Mikhail Yarema, 2017-10-27 11:33:18

How to send sql update request to node.js?

callback fires but data is not updated

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('Документ изменен');
  });
});

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question