print SQL output in jade file

I’m trying to output an sql query in Jade file. I got it so far that I can print plain text to jade but when I try to put an output from SQL it doesn’t work can someone help me.

The code in app.js (NodeJS) :

con.query('SELECT * FROM user ', function(err, rows)
{
    console.log('Connection result error '+err);
    console.log('num of records is '+rows.length);
    //console.log(rows);

    res.render('index',
        { title : 'Home' }
    )
    res.render('index',
        { row : res.send(rows) }
    )
    console.log('num of records is '+rows.length);
});

The code in jade (What I have at the moment):

  - each row in rows
        p=row.first_names

Answer

You only need to call render once like this:

res.render('index', {
  title: 'Home',
  rows: rows
});

The single call contains the object with all of the values you want passed to the Jade template. Also note the change of the key row to rows since that is what you called it in your template, as well as not calling res.send inside of res.render

Advertisement

Answer