This is the error but I am not able to pinpoint it. The query runs fint when run from phpmyadmin SQL console
var query = connection.query('Select distinct a.*, IFNULL(b.scannerid,'Not Available') AS `scannerid`, IFNULL(date(b.datetime),'Not Available') as datetime, IFNULL(b.status,'Absent') AS `status` from studentdetails a LEFT OUTER JOIN discovereddevices b ON a.bluetoothid = b.blueid and date (b.datetime) = CURRENT_DATE',function(err,rows)
The error:
SyntaxError: missing ) after argument list
at createScript (vm.js:53:10)
at Object.runInThisContext (vm.js:95:10)
at Module._compile (module.js:543:28)
at Object.Module._extensions..js (module.js:580:10)
at Module.load (module.js:488:32)
at tryModuleLoad (module.js:447:12)
at Function.Module._load (module.js:439:3)
at Module.require (module.js:498:17)
at require (internal/module.js:20:19)
at Object.<anonymous> (/home/ubuntu/Attendance system/app.js:13:24)
The Javascript code:
exports.getattendance = function(req, res){
req.getConnection(function(err,connection){
var query = connection.query('Select distinct a.*,
IFNULL(b.scannerid,'Not Available') AS `scannerid`,
IFNULL(date(b.datetime),'Not Available') as datetime,
IFNULL(b.status,'Absent') AS `status` from studentdetails a LEFT OUTER
JOIN discovereddevices b ON a.bluetoothid = b.blueid and date (b.datetime)
= CURRENT_DATE',function(err,rows)
{
if(err)
console.log("Error Selecting : %s ",err );
res.render('showreport',{page_title:"Attendance Report Generated",data:rows});
});
//console.log(query.sql);
});
};
via yuvasree kalaiselvan
No comments:
Post a Comment