parseFloat not changing string value in sql to float

Question

I am using node-mysql and have 2 rows. I am adding together the 'total' column which values are 1.10 and 1.16 obviously expecting total to be 2.26

I am querying the table, and the adding them as follows:

connection.query(q3, function (err, results) {
    if (err) throw err;
    var totalSum=0;
    for(i=0; i<results.length;i++) {
        totalSum = totalSum + parseFloat(results[i].total).toFixed(2);
    }

However my totalSum returns as 01.101.16 which shows as a concatenation of strings. Why is my parseFloat not changing the string obtained from sql?

Thanks

@maioman if the .toFixed() is still there that will make absolutely no difference. — Pointy
– Pointy, Commented Apr 12, 2016 at 15:00
@Pointy I meant Number( (results[i].total).toFixed(2) ) for converting it back to number but OP shouldn't use toFixed(2) to begin with — maioman
– maioman, Commented Apr 12, 2016 at 15:13

Pointy · Accepted Answer · 2016-04-12 14:59:48Z

3

If you want to format the sum as a number with two places past the decimal point, do so after the total has been calculated. The .toFixed() function returns a string, not a number.

answered Apr 12, 2016 at 14:59

Pointy

415k62 gold badges600 silver badges631 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Volodymyr Sichka · Accepted Answer · 2016-04-12 15:03:54Z

0

Try this:

totalSum = (totalSum + parseFloat(results[i].total)).toFixed(2);

answered Apr 12, 2016 at 15:03

Volodymyr Sichka

5614 silver badges10 bronze badges

1 Comment

Pointy Over a year ago

Because .toFixed(2) will return a string, this will have exactly the same problem as the original.

Lewis · Accepted Answer · 2016-04-12 15:22:56Z

0

There is no point to use toFixed within the loop. It should be called on the sum.

let totalSum = results.reduce((prev,curr) => prev.total + curr.total).toFixed(2);

answered Apr 12, 2016 at 15:22

Lewis

15k14 gold badges70 silver badges88 bronze badges

Collectives™ on Stack Overflow

parseFloat not changing string value in sql to float

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related