I am coding a node module with
mssql
sp_recordset
[{name:'num',type:'Int',value:2},
{name:'num1',type:'Int',value:1}]
exports.sp_recordset = function(conex, storedProcedure, parameters, cb) {
var connection = new mssql.Connection(conex, function(err) {
if(err){
console.log(err);
}
var request = new mssql.Request(connection);
for(index=0;index<parameters.length;++index)
{
request.input(parameters.name, mssql.Int, parameters.value);
}
request.execute(storedProcedure, function(err, recordsets, returnValue) {
if(err){
console.log(err);
}
cb(recordsets);
});
});
};
request.input(parameters.name, mssql.Int, parameters.value);
mssql
request.input(parameters.name, mssql.(parameters.type), parameters.value);
It looks like you're trying to access variable property by its name, not to assign it.
If so, the following should work for you:
request.input(parameters.name, mssql[parameters.type], parameters.value);