I am using express and I am trying to call LoginMember stored procedure from Azure portal. This is my form from, taken from ejs:
- <form method="post" action="/available-copies">
- <input type="text" placeholder="SSN" name="userssn">
- <input type="password" placeholder="Password" name="userpassword">
- <input type="submit" value="Login">
- </form>
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);
-
- var request = new sql.Request();
-
- request.query("exec LoginMember @SSN='"+ssn+"', @PASSWORD='"+password+"';", function (err, recordset) {
- if (err) console.log(err);
-
- res.send(recordset);
- });
- });
- sql.close()
- });
Thanks in advance