How to delete specific row from sql server using nodeJs

Question

I am using nodeJs as a backend language and sql server as a database. I can to delete whole table row from database but can not able to delete specific row. Here is my code...

router.delete('/student/:id', function (req, res, next) {
var connection = new Connection(config);
connection.on('connect', function(err) {
    request = new Request("DELETE FROM student where id=@id", function(err) {
        if (err) { console.log(err);}
    });

    request.addParameter('id');

    request.on('done', function(rowCount, more) {  console.log(rowCount + ' rows returned');   });
    connection.execSql(request);
    res.setHeader('Content-Type', 'application/json');
});

});

d_shiv · Accepted Answer · 2017-11-30 07:08:11Z

1

The problem here seems to be the call to addParameter() function with incomplete list of arguments. request.addParameter() expects three arguments, viz. parameter name, data type, value. You only provided the parameter name.

Try changing request.addParameter('id'); to something like this:

var TYPES = require('tedious').TYPES; // Get the TYPES enum.
request.addParameter('id', TYPES.Int, parseInt(req.params.id)); // Assuming your id is an integer. Use proper Types enum, and conversion, if its not.

You can also refer the example on Microsoft website here: https://learn.microsoft.com/en-us/sql/connect/node-js/step-3-proof-of-concept-connecting-to-sql-using-node-js

answered Nov 30, 2017 at 7:08

d_shiv

1,80010 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to delete specific row from sql server using nodeJs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related