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