Monday, 15 May 2017

Multiple select query in node js

Hello Guys i am newbie in node js, i have a jade framerwork where i have two html options in which i have to get the data from different different sql, If i am doing it with one sql and one html option the everything went fine but as soon as i perform multiple sql it gives me Type Error my js code is:

    exports.Questions = function (req, res) {
    var con = mysql.createConnection({
    host : 'localhost',
    user : 'root',
    password : '',
    database : 'nodeutility',
    multipleStatements: true
});
//res.render('Subcategory', { title: 'Subcategory', year: new Date().getFullYear(), message: 'Your Subcategory page' });
con.connect();
var sql = 'SELECT * FROM mst_category';
con.query(sql, function (err, rows, fields) {
    if (err) throw err;
    res.render('Questions', { title: 'Users', rows: rows });
    res.end;

});
var sql1 = 'SELECT * FROM mst_subcategory';
con.query(sql1, function (err, rows1, fields) {
    if (err) throw err;
    res.render('Questions', { title: 'Users', rows1: rows1 });
    res.end;

});
 con.end();
 };

and my jade code is this:

            div.form-group
            label(for='name') Select Category:
            select#catname.form-control(name='catname')
                each item in rows
                    option(value=item.id) #{item.Name}
            div.form-group
            label(for='name') Select Sub-Category:
            select#subname.form-control(name='subname')
                each item1 in rows1
                    option(value=item1.id) #{item1.Name}



via user1870546

No comments:

Post a Comment