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?

score 2 · Answer 1 · answered Nov 09 '15 at 14:48

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 09 '15 at 14:48

matanso

1,284
1
10
17

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 Nov 09 '15 at 15:51
When i log the value of PNOP it says undefined. – Wise Bulls Nov 09 '15 at 15:51
Yes - i tried it as it is - the var value was not getting set. so i added a line – Wise Bulls Nov 09 '15 at 15:54
console.log(results[0].pnop) - and in the log it was getting recorded as 7915.20 – Wise Bulls Nov 09 '15 at 15:54

nodejs how to retrieve variable value from mysql

1 Answers1