nodejs how to retrieve variable value from mysql

Question

I have a piece of code where I want to get the value of a variable from mysql database.

var PNOP;

  connection.query('SELECT pnop FROM MASTER1', [PNOP], function(err, results) {
  console.log(results);
 });

The connection query is working fine but the var PNOP is not getting updated.

The log file is showing the following entry:

[ { pnop: 7915.2 } ]

The value that I need to set as PNOP is 7915.2 which is what is in the mysql database.

What should I do to get the variable value?

matanso · Accepted Answer · 2015-11-09 14:48:28Z

2

The way nodejs-mysql works, the second parameter for the query contains the values of the fields you want to escape, and not the output parameters. The result of the query is in "results", as your log shows. what your code should be is:

var PNOP;

connection.query('SELECT pnop FROM MASTER1', [], function(err, results) {
  PNOP = results[0].pnop;
 });

answered Nov 9, 2015 at 14:48

matanso

1,3021 gold badge10 silver badges17 bronze badges

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

4 Comments

Wise Bulls Over a year ago

The results[0].pnop is giving the correct value - when i log it. However, the var PNOP value does not seem to be getting set with this value.

Wise Bulls Over a year ago

When i log the value of PNOP it says undefined.

Wise Bulls Over a year ago

Yes - i tried it as it is - the var value was not getting set. so i added a line

Wise Bulls Over a year ago

console.log(results[0].pnop) - and in the log it was getting recorded as 7915.20

Collectives™ on Stack Overflow

nodejs how to retrieve variable value from mysql

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related