node.js Count MySQL Query with LIMIT

Question

I try to get the number of found rows out of a mysql query with a limitation. Google gave me the hint with the SQL_CALC_FOUND_ROWS function.

I also get the right result in the "RowDataPackage".

RowDataPacket { 'FOUND_ROWS()': 5 }

But when i try to parse the result with

console.log(rows[0].FOUND_ROWS());

I only get the result "undefined". What am i doing wrong?

Possible duplicate of How to access object properties containing special characters? — Tomalak
– Tomalak, Commented Mar 7, 2017 at 7:39
rows[0].FOUND_ROWS() is a function call, can you alias your query to return proper column name? — slier
– slier, Commented Mar 7, 2017 at 7:40
This is not a node.js question and not a MySQL question. This is a basic JavaScript syntax question. — Tomalak
– Tomalak, Commented Mar 7, 2017 at 7:40

Tim Biegeleisen · Accepted Answer · 2017-03-07 07:42:08Z

1

Try this:

console.log(rows[0]["FOUND_ROWS()"]);

Your current call is being interpreted as a function call. Instead, use square brackets to escape the key name in your JSON.

As @Tomalak mentioned, your question doesn't have too much to do with MySQL, rather just regular JavaScript.

answered Mar 7, 2017 at 7:42

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

1 Answer 1