nodejs mysql 分页通过准备好的查询语句返回错误每个属性未定义

Question

下面的nodejs代码在用于从数据库中检索内容时工作正常。 现在，当我尝试通过准备好的查询语句按照下面的代码通过分页获取内容时

db.query('SELECT * FROM posts1 limit row=?, rowperpage=?', [parseInt(row),parseInt(rowperpage)], function (error, results, fields) {
});

它返回错误">无法读取每个未定义的属性">

以下是完整代码

exports.display = function (req, res) {
var row = 0;
var rowperpage = 3;
console.log(row);
console.log(rowperpage);

var objs1 = []; 
db.query('SELECT * FROM posts1 limit row=?, rowperpage=?', [parseInt(row),parseInt(rowperpage)], function (error, results, fields) {
// db.query('SELECT * FROM posts1', function (error, results, fields) {
results.forEach(function(row) {
var id = row.id;
var title = row.title;
var content = row.content;
var shortcontent = row.content;
var link = row.link;

objs1.push({
id: id, 
title: title,
shortcontent: shortcontent,
content: content,
link: link,
});
});
res.end(JSON.stringify(objs1));
});

}

Answer 1

在下面添加以下代码，解决问题

//parse int Convert String to number 
let startNum = parseInt(row);
let LimitNum = parseInt(rowperpage);

var objs1 = []; 
db.query("SELECT * FROM ?? limit ? offset ?", ["posts1",LimitNum,startNum], function (error, results, fields) {

谢谢