NodeJs express4-tedious - Stored Procedure for SELECT to return response as JSON

[samu7]

Couldn't show the response in JSON while using a stored procedure.

I'm using express4-tedious to fetch results. It works fine if I use the select query but if I use the same with the stored procedure I don't know how to bind it in JSON.

The response screen is blank as I couldn't get the results.

var tediousExpress = require('express4-tedious');
var TYPES = require('tedious').TYPES;
var router = express.Router();
router.get('/:id', function (req, res) {
    req.sql("exec GETDataOfEmployee @id")
    .param('id', req.params.id, TYPES.VarChar)
    .exec(res)
});

Any suggestions would be of great help.

[JocaPC]

That should work. Could you put fail procedure to catch some error?

…

On Tue, 6 Aug 2019, 08:28 samu7, ***@***.***> wrote: Couldn't show the response in JSON while using a stored procedure. I'm using express4-tedious to fetch results. It works fine if I use the select query but if I use the same with the stored procedure I don't know how to bind it in JSON. The response screen is blank as I couldn't get the results. var tediousExpress = require('express4-tedious'); var TYPES = require('tedious').TYPES; var router = express.Router(); router.get('/:id', function (req, res) { req.sql("exec GETDataOfEmployee @id") .param('id', req.params.id, TYPES.VarChar) .exec(res) }); Any suggestions would be of great help. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#8?email_source=notifications&email_token=AAI2LZVONAGQLWOXWYPQHOTQDEKZZA5CNFSM4IJS5SN2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HDRMTNA>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAI2LZTUNAF4PE4I3Q5VGFTQDEKZZANCNFSM4IJS5SNQ> .