Calling stored procedure from node js

I am using express and I am trying to call LoginMember stored procedure from Azure portal. This is my form from, taken from ejs:

This is my post request

router.post('/available-copies', function (req, res) {
var ssn = req.body.userssn;
var password = req.body.userpassword;
sql.connect(sqlConfig, function (err) {
if (err) console.log(err);
// create Request object
var request = new sql.Request();
// query to the database and execute procedure
request.query("exec LoginMember @SSN='"+ssn+"', @PASSWORD='"+password+"';", function (err, recordset) {
if (err) console.log(err);
res.send(recordset);
});
});
sql.close()
});

Thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.