When I do this, nothing is displayed. That drives me crazy. Here is my
html teample completely:
<div class="container">
<div class="row">
<h2>Number of Applications</h2>
{{#if applications}}
{{#each applications}}
<div class="col-lg-2">
<div class="alert alert-success" role="alert">
<p style="font-size:75px; text-align:center;">{{grade7}}</p>
<p style="text-align:center;"><strong>7th GRADE
Applications <strong> </p>
</div>
</div>
<div class="col-lg-2">
<div class="alert alert-warning" role="alert">
<p style="font-size:75px; text-align:center;">{{grade8}}</p>
<p style="text-align:center;"><strong>8th GRADE
Applications <strong> </p>
</div>
</div>
{{/each}}
{{else}}
<p>No Applications</p>
{{/if}}
</div>
</div>
</div>
On Wednesday, January 25, 2017 at 1:18:50 PM UTC-6, Muhammad Wasim wrote:
>
> Set it as following
>
> *router.get('/dashboard', getGrade7Applicants, getGrade8Applicants,
> function (req, res, next) {*
> * res.render('admission/dashboard', {*
> * 'grade7': req._applications7,*
> * 'grade8': req._applications8,*
>
> * });*
> *});*
>
> *And here is my html template. I use handlebars. *
>
> <div class="alert alert-success" role="alert">
> <p style="font-size:75px; text-align:center;">{{grade7}}</p>
> <p style="text-align:center;"><strong>7th GRADE Applications
> <strong> </p>
> </div>
>
> <div class="alert alert-success" role="alert">
> <p style="font-size:75px; text-align:center;">{{grade8}}</p>
> <p style="text-align:center;"><strong>8th GRADE Applications
> <strong> </p>
> </div>
>
> Muhammad Wasim.
>
> On 25 Jan 2017 12:26 a.m., "Fatih Karatay" <[email protected]
> <javascript:>> wrote:
>
> *Here is the router js file that I use :*
>
>
> *//connection variables*
> *var connection = mysql.createConnection({*
> * host: 'localhost',*
> * port: '3306',*
> * user: 'root',*
> * password: '12345*',*
> * dateStrings: true,*
> * database: 'database'*
>
> *});*
>
> *connection.connect();*
>
>
> *function getGrade7Applicants(req, res, next) {*
> * connection.query('SELECT COUNT(*) AS grade7 FROM applications WHERE
> grade="Grade 7" ', function (err, rows, fields) {*
> * if (err) {*
> * return next(err);*
> * };*
> * req._applications7 = rows;*
> * return next();*
> * });*
> *}*
>
> *function getGrade8Applicants(req, res, next) {*
> * connection.query('SELECT COUNT(*) AS grade8 FROM applications WHERE
> grade="Grade 8" ', function (err, rows, fields) {*
> * if (err) {*
> * return next(err);*
> * };*
> * req._applications8 = rows;*
> * return next();*
> * });*
> *}*
>
>
>
> */* GET dashboard page */*
>
> *router.get('/dashboard', getGrade7Applicants, getGrade8Applicants,
> function (req, res, next) {*
> * res.render('admission/dashboard', {*
> * 'applications': req._applications7,*
> * 'applications': req._applications8,*
>
> * });*
> *});*
>
> *And here is my html template. I use handlebars. *
>
> <div class="alert alert-success" role="alert">
> <p style="font-size:75px; text-align:center;">{{grade7}}</p>
> <p style="text-align:center;"><strong>7th GRADE Applications
> <strong> </p>
> </div>
>
> <div class="alert alert-success" role="alert">
> <p style="font-size:75px; text-align:center;">{{grade8}}</p>
> <p style="text-align:center;"><strong>8th GRADE Applications
> <strong> </p>
> </div>
>
> *I know there is override in here. What would be best way to display those
> count values from the same table in the same page?*
>
> On Wed, Jan 11, 2017 at 4:41 AM, Alex Wells <[email protected]
> <javascript:>> wrote:
>
>> You're probably not decoding the JSON in the client and then choosing the
>> right variables. I haven't got your Template so I can't help you fix that,
>> but you'll need to reference the 'data.grade6Rows' and 'data.grade7Rows'
>> objects you created, rather than the '_applications.grade6Rows' you were
>> referencing previously.
>>
>>
>> On Wednesday, 11 January 2017 01:54:28 UTC, Fatih Karatay wrote:
>>>
>>> When I try your solution, this time nothing is displayed. Am I missing
>>> anything?
>>>
>>> On Tuesday, January 10, 2017 at 7:35:49 AM UTC-6, Alex Wells wrote:
>>>>
>>>> Just so you know, it's a bit weird to set a 'private' property on an
>>>> object you don't own:
>>>>
>>>> req._applications = rows;
>>>>
>>>>
>>>> although this is just by convention, if you were to log a bug with
>>>> something I had developed where you'd made use of the above, I would
>>>> probably ask you to change this first. If you want to set something on the
>>>> req object, most people set a 'data' variable like so:
>>>>
>>>> req.data = {
>>>>
>>>> grade6Rows: rows;
>>>>
>>>> };
>>>>
>>>>
>>>> In the above is also the solution - you are setting the same property
>>>> both times ('_applications') so it's getting overwritten by subsequent
>>>> callbacks. You need to place multiple properties in the 'req' object for
>>>> each resultset.
>>>>
>>>> You would do that in each callback with something like this;
>>>>
>>>> req.data = req.data || {};
>>>>
>>>> req.data['grade6Rows'] = rows;
>>>>
>>>>
>>>> Remember to decode the JSON on the client, and you'll have an object
>>>> you can iterate.
>>>>
>>>> On Thursday, 5 January 2017 21:04:06 UTC, Fatih Karatay wrote:
>>>>>
>>>>> 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] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/nodejs/75ac96b4-05d4-4948-b2ec-699a86001c8b%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/nodejs/75ac96b4-05d4-4948-b2ec-699a86001c8b%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>
> --
> Fatih Karatay
> Dove Science Academy Tulsa
>
> --
> 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] <javascript:>.
> To post to this group, send email to [email protected] <javascript:>
> .
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/nodejs/CAASE%3DRhT-UF8Ty63BOo-TLgZj-E9R7MfKguBPYsPxLoCjunH%2BQ%40mail.gmail.com
>
> <https://groups.google.com/d/msgid/nodejs/CAASE%3DRhT-UF8Ty63BOo-TLgZj-E9R7MfKguBPYsPxLoCjunH%2BQ%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
>
>
--
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/81a48ca7-b7e0-467e-8ad0-243bddb43199%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
