function getAllUsers1 (){
var con = new sql.connect(config,(err)=>{
if(err){
console.log(err)
return err ;
}else{
console.log('1');
con.query("select * from WebMail_Send", function (err,data){
if(err){
console.log('invaled query..............');
return err ;
}else{
console.log(data);
return data;
}
})
}
});
}
router.get('/sql',(req,res,next)=>{
var getAllUsers = new getAllUsers1();
res.render('sql', { items: getAllUsers})
});
No Error but return nothing
I'm trying to get data from SQL DB and display it on the HBS page.