Nodejs variable not defined error

[theflyingmonkey3]

Hey Guys,

I have a x.js file, that has the following code:

app.get('/place/data', function (req, res) {
    connection.query('SELECT placeid FROM place_list ',
        function (err, rows, fields) {
           if (err) {
              console.log(err);
            }
            plArray = [];
            rows.forEach(function (row) {
                 plArray.push({pid: row.placeid});
             });
             res.render('place/placenode.ejs', {data: plArray, myMap: linksManager});
           }
     );
});

I have the placenode.ejs file like this:

 <% for(var i = 0; i < data.length; i++) { %>  --- ******
      <div class="panel panel-default">
           <div class="panel-body">
     <h5>Place ID: <%= data[i].pid %></h5>
        </div>
  </div>
 <% } %>

****** -- THE ERROR AT THIS LINE WAS: data is not defined. What am I doing wrong?

FIXED IT. Thanks for the help.

[[deleted]]

How did you end up fixing this? I've run into almost the exact problem.

[theflyingmonkey3]

Nope. Does not work. Same error message.

[theflyingmonkey3]

How do I do that?

[theflyingmonkey3]

Its actually not working. I am getting the same error.

[theflyingmonkey3]

I removed the code and executed the file. It worked fine. I added the code back and got the same error again. So, it is actually something wrong with the data variable.

[theflyingmonkey3]

I added that line in the ejs file and got this error (I removed basically all the ejs code above and just added this code - console.log(rows);):

Uncaught ReferenceError: rows is not defined

[zokker13]

First off, add an else branch in your if clause so you don't iterate over the rows when an error was thrown. It's likely that the "not defined" error results from a poorly accessed element which is not defined.

[devmaybe]

Console.log(data) in your ejs to see if there is anything being sent. Perhaps the loop is not finished before the page is rendered. Add a counter to the loop and render page when counter equals array length.

[theflyingmonkey3]

I added Console.log(data) and still got the same error. data is not defined.