how does Node.js get the value of the out parameter after executing the mysql stored procedure with the out parameter? I want to get the values of the two parameters _ totalcount,_pagecount, but the return value is not in rows. The code is as follows:
ssql = "call sp_MvcCommonDataSource(?,?,?,?,?,?,?,@_totalcount,@_pagecount,@ss)";
sqlParam=["*","article","","id",pageindex,pagesize,""];
connection.query(sql,sqlParam, function (err, rows, fields) {
if (err) {
throw err;
console.log(":" + err);
}
else {
json = JSON.stringify(rows)
console.log(":" + json);
// res.send(json);
}