moshekarmel1 / node-sql Goto Github PK

Hello, I am noticing a problem when I am calling a SQL proc and it errors. For instance, let's say that my proc 'BooksInsert' expects 5 params but I only provide 4...I would expect an error to be thrown. If I call the following code:

nodeSql.sproc('GLIWeb.dbo.BooksInsert', req.body, config, function(err, result){
if (err) {
console.log('I have an error', err);
return res.status(500).send(err);
}
else {
console.log('i do not have an error', err);
res.status(201).json(result);
}
})
nodeSql is running through the callback with err = NULL (thus hitting "i do not have an error" section) and then it immediately runs again but this time err is not NULL so it gets into the "I have an error" section. However, since the response status has already been set (because of the initial runthrough), node is now throwing the "Cant set headers after they are sent" error.

Am I missing something? Why is nodeSql running this twice (once without an error and then another time with an error)?