Passing additional parameters to callback

Question

I am using mssql in node.js executing an SP:

var fnGetMapping = function(results) {

        new sql.Request(db.sqlConnection)
            .input('myParam', sql.VarChar(60), 'myValue')
            .execute('usp_MySP', fnProcessUUIDData);
};

Now my fnProcessUUIDData looks like this:

var fnProcessUUIDData = function(err, recordsets) {
    if (err) {
        console.log("Error calling MS SQL: " + err.message);
    } else {
        if (recordsets[0].length > 0) {

        } else {

        };
    }
};

What I need now is to pass one of my own parameter into fnProcessUUIDData.

I read some articles that this is possible but I couldn't get it working on my case, would appreciate some comments if what I want to do is possible.

Lewis · Accepted Answer · 2016-08-16 14:07:11Z

3

You can use apply to pass some extra arguments without loosing the context.

new sql.Request(db.sqlConnection)
  .input('myParam', sql.VarChar(60), 'myValue')
  .execute('usp_MySP', function(...args) {
    fnProcessUUIDData.apply(this, args.concat(some, extra, parameters));
  });

var fnProcessUUIDData = function(err, recordsets, some, extra, parameters) {
  console.log(this, some, extra, parameters);
};

edited Aug 16, 2016 at 14:07

answered Aug 16, 2016 at 13:49

Lewis

15k14 gold badges70 silver badges88 bronze badges

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

Comments

slebetman · Accepted Answer · 2016-08-16 23:56:14Z

2

Using apply overcomplicates things because fnProcessUUIDData is a plain old function and not a method (it doesn't use this internally). All you need to do is wrap it in another function:

new sql.Request(db.sqlConnection)
  .input('myParam', sql.VarChar(60), 'myValue')
  .execute('usp_MySP', function(err, recordsets) {
    fnProcessUUIDData(err, recordsets, additional_parameter);
  });

answered Aug 16, 2016 at 23:56

slebetman

115k19 gold badges148 silver badges181 bronze badges

Collectives™ on Stack Overflow

Passing additional parameters to callback

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related