Node/Express render multiple postgres queries on same html file

Question

I have a query that returns results from my database, but I don't see how I can have it give me results from multiple queries.

router.get("/", function(req, res) {
  pg.query("SELECT * from tic", (err, done) => {
    if (err) {
      console.log(err);
    }
    res.render("index", { tic: done.rows });
  });
});

I was trying along the lines of this, but cant get it to work since he render statement is inside the query and I can get the render to see the results when I move it out of there

router.get("/", function(req, res) {
  pg.query("SELECT * from tic", (err, tic) => {
    if (err) {
      console.log(err);
    }
  pg.query("SELECT * from tac", (err, tac) => {
    if (err) {
      console.log(err);
    }
  });
  res.render("index", { tic: tic.rows }, { tac: tac.rows});
});

wrap both the queries in promises and combine their results once both are done — Rishikesh Dhokare
– Rishikesh Dhokare, Commented Aug 4, 2018 at 17:15

blakemade · Accepted Answer · 2020-09-25 09:50:29Z

1

You just have to render after the second query executes. To do that you have to render in the callback of the second query.

router.get("/", function (req, res) {
    pg.query("SELECT * from tic", (err, tic) => {
        if (err) {
            console.log(err);
        }
        pg.query("SELECT * from tac", (err, tac) => {
            if (err) {
                console.log(err);
            }
            res.render("index", { tic: tic.rows }, { tac: tac.rows });
        });
    });
});

edited Sep 25, 2020 at 9:50

blakemade

1076 bronze badges

answered Aug 4, 2018 at 17:20

eskawl

6371 gold badge5 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Node/Express render multiple postgres queries on same html file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related