Accessing a variable that is outside an anonymous function

Question

I have this simple code

 orm: function (req, res) {

    // Send a JSON response


       Noder.query('SELECT * FROM crud ', function(err, results) {
        var all_rows = Noder.query('SELECT count(*) from crud ', function(err, the_rows) {
        return the_rows;
        });

         res.view('noder/orm', {
            layout: 'layout',
            allr:all_rows,
            post:results,
            title: 'This is the hi page title. '
        }); 
      });
   },

which i am using to fetch all rows in a mysql table. However inside that function,i want to have another function that counts how many rows there are in the table.My variable var all_rows shows me undefined when i try displaying it. How can i solve this?.

Do not return the_rows, put res.view('noder/orm', { layout: 'layout', allr:all_rows, post:results, title: 'This is the hi page title. ' }); inside Noder.query success callback — Rayon
– Rayon, Commented Dec 25, 2015 at 17:14

Mike Lawson · Accepted Answer · 2015-12-25 17:16:59Z

1

This is because you are accessing the value of all_rows before the inner-query has returned.

Noder.query is an asynchronous function, and as such, its execution will be delayed until the query itself is completed. Meanwhile, your orm function will continue merrily down and call res.view while your inner query is still processing.

To fix this, you can call res.view from inside your inner query.

answered Dec 25, 2015 at 17:16

Mike Lawson

7356 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Accessing a variable that is outside an anonymous function

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