`
const sql = require("mssql/msnodesqlv8");
//database congigurSEation
var config = {
user: "USERNAME",
password: "SIFRE",
database: "UpShift",
server: "DESKTOP-EH2NO0D\\SQLEXPRESS",
driver: "msnodesqlv8",
optiions: {
trustedConnettion: true,
},
};
// connet to database
sql.connect(config, function (err) {
if (err) {
console.log(err);
}
//create teh request object
var request = new sql.Request();
//database query
request.query("select * from ulogin", function (err, recordSet) {
if (err) {
console.log(err);
}else {
console.log(recordSet);
}
});
});
`
ReferenceError: recordSet不是在对象处定义的。(C:\Users\LENOVO\Downloads\dmin_dashbaord_v23_html_css_js_bootstap5-main\index.js:38:1) at Module._compile (节点:内部/模块/cjs/加载程序:1159:14),在Module._extensions..js (节点:内部/模块/cjs/加载程序:1213:10),在Module.load (节点:内部/模块/cjs/加载程序:1037:32),在Function.executeUserEntryPoint (节点: Module._load /模块/cjs/加载程序:878:12)。节点处的as runMain:内部/main/run_main_模块:23:47
发布于 2022-11-16 05:06:19
试试这个;
const result = request.query("select * from ulogin");
console.log("Result: ",result.recordsets); // or 'recordset' for first array
https://stackoverflow.com/questions/74428330
复制相似问题