[BUG] mssql responed recordset null but rowseffected count is there

[anilmehx]

I am using "connect-mssql-v2": "^3.1.3" and "mssql": "^7.3.5". While mssql request execute i am getting response with null recordset even though there is rowseffected count. Below is the code i am using.

const session = require("express-session");
const MSSQLStore = require("connect-mssql-v2");
const sql = require("mssql");

var sqlConfig = {
  user: config.sqlExtDbUserName,
  password: config.sqlExtDbPassword,
  server: config.sqlExtDbServerName,
  database: config.sqlExtDbName,
  port: config.sqlExtDbServerport,
  options: {
    encrypt: true,
    trustServerCertificate: true,
  },
};

var option = {
  ttl: 100060608, //set session expiry as 8 hours
  autoRemove: "interval",
  autoRemoveInterval: 100060 * 60, //delete expired session after 1 hour
};

app.use(
  session({
    name: "session",
    store: new MSSQLStore(sqlConfig, option),
    secret: config.sessionKey,
    resave: true,
    saveUninitialized: false,
    cookie: { secure: true, sameSite: true },
  })
);

request = new sql.Request(connection);
if (parameterList) {
  for (const param of parameterList) {
    request.input(
      param.parameterName,
      param.parameterType,
      param.parameterValue
    );
  }
}

result = await request.execute(procedureName);

[JLuboff]

It seems like there is some code missing here (what is parameterList, connection, etc), but ultimately, this appears to have to do with your mssql query and not this package which is handling sessions which uses mssql under the hood.

[bradtaniguchi]

@anilmehx I just edited your post to help with readability.

Please provide more details as mentioned above, thanks!

[JLuboff]

Closing due to inactivity.