I have a web page that displays number of applications in certain grades.
For example, number of applications in grade 6, grade 7 and grade 8. The
functions that I use for grade 6 and grade 7 are as below:
function getGrade6Applicants(req, res, next) {
connection.query('SELECT COUNT(*) AS grade_6 FROM applications WHERE
grade="Grade 6" ', function (err, rows, fields) {
if (err) {
return next(err);
};
req._applications = rows;
return next();});}
function getGrade7Applicants(req, res, next) {
connection.query('SELECT COUNT(*) AS grade_7 FROM applications WHERE
grade="Grade 7" ', function (err, rows, fields) {
if (err) {
return next(err);
};
req._applications = rows;
return next();});}
Then, I use this function to my GET request as below. If it's just for
grade_6, it works fine. The name of the mysql table is "applications".
/* GET dashboard page */
router.get('/dashboard', getGrade6Applicants, function (req, res, next) {
res.render('admission/dashboard', {
'applications': req._applications
});})
This gives me the number of applications in grade6 in my applications table
in mysql database.
I use this in my dashboard.handlebars page as {{grade_6}} using appropriate
{{#if}} and {{#each}} built in helpers.
The problem is whenever I wanted to add *second *function to display number
of applications in grade 7, what I have is only grade 7 applications. Grade
6 is not shown. Here is the GET request that I use for multiple values:
/* GET dashboard page */
router.get('/dashboard', getGrade6Applicants, getGrade7Applicants, function
(req, res, next) {
res.render('admission/dashboard', {
'applications': req._applications
});})
--
Job board: http://jobs.nodejs.org/
New group rules:
https://gist.github.com/othiym23/9886289#file-moderation-policy-md
Old group rules:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nodejs/b01aac93-fca6-4293-81e2-864125cf3e6b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
