How do I send multiple objects to .ejs file

Question

I am trying to pass a query from MySQL to .ejs file, and send object at the same time.

In the following code, I am trying to send rows and { pageTitle: "Edit Agents" } to edit_agents page

Router.get("/", (req, res) => {
  mysqlConnection.query("select * from agent", (err, rows, fields) => {
    if (!err) {
      res.render("edit_agents", rows);
      res.render("edit_agents", { pageTitle: "Edit Agents" });
    } else {
      console.log("error");
    }
  });
});

Just to let you know, I am using NodeJs (express framework) with ejs views.

Answer 1

Router.get("/", (req, res) => {
  mysqlConnection.query("select * from agent", (err, rows, fields) => {
    if (!err) {
      res.render("edit_agents", { data: rows,pageTitle: "Edit Agents" });
    } else {
      console.log("error");
    }
  });
});