Returning multiple datasets to a Node.js View

Question

This is in my routes/product.js file in my node.js/express project which is using express-myconnection. How do I return multiple data sets for the view to use? I have the data object and the dropdown object being populated by the same query. I want to keep the data object like it is, but populate the dropdown object with a different query.

exports.edit = function(req, res) {
    var id = req.params.id;
    req.getConnection(function (err, connection) {
        connection.query('SELECT * FROM products WHERE product_id = ?', [id], function (err, rows) {
            if (err)
                console.log("Error Selecting : %s ", err);
            res.render('products\\edit', {
                page_title: "Product : Edit",
                save_button_title: "Update",
                data: rows,
                dropdown:rows});
        });
    });
}

Community · Accepted Answer · 2017-05-23 10:25:58Z

1

You can either nest another database call inside your first "success" area or you can try something like this: Node.js - wait for multiple async calls

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Oct 9, 2014 at 5:33

HeadCode

2,8261 gold badge17 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

Returning multiple datasets to a Node.js View

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related