How set a value within connection.query function nodejs

Question

I am trying to push rows in dataArray but it returns a blank array in the response.

 let dataArray = [];
            for (let id=1; id <= 5; id++) {
                dbConnection.query("SELECT firm_name, id FROM stockist WHERE id=?", id, function (error, rows) {
                    if (error) throw error;
                    else {
                        dataArray.push(rows);
                    }
                });
                // console.log("data "+id+" :", data);
            }

Does this answer your question? How to pass parameters to mysql query callback in nodejs — Nikhil Bhandari
– Nikhil Bhandari, Commented Jul 25, 2020 at 11:43
Danizavtz thanks for your response. I am using mysql database. — Gopal Dutt
– Gopal Dutt, Commented Jul 25, 2020 at 11:58
thanks Nikhil Bhandari. this is not my problem, I want to push rows into global variable dataArray. — Gopal Dutt
– Gopal Dutt, Commented Jul 25, 2020 at 12:05

Mr Khan · Accepted Answer · 2020-07-25 12:35:32Z

1

You are using Async / Await which is an asynchronous operation hence it won't be possible for you to print the data outside of async. Hence you are going to have to store the async result in a variable and then simply check if data exist then print.

   let dataArray = [];

   for (let id=1; id <= 5; id++) {
        let result = null;
        result = await dbConnection.query("SELECT firm_name, id FROM stockist WHERE id=?", id);
        if (result) {
           console.log(result) //=====> it should contain all rows
           dataArray.push(result);
           // console.log("data "+id+" :", data);
        }
    }

edited Jul 25, 2020 at 12:35

answered Jul 25, 2020 at 12:05

Mr Khan

2,3061 gold badge9 silver badges27 bronze badges

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

4 Comments

Gopal Dutt Over a year ago

thanks Mr. Khan. But I want to push rows data into dataArray. is that possible?

Mr Khan Over a year ago

Done. Check now. You don't need callback since you are using async/await just console.log it and you will find all rows in the result.

Gopal Dutt Over a year ago

<ref *1> Query { _events: [Object: null prototype] { error: [Function (anonymous)], packet: [Function (anonymous)], timeout: [Function (anonymous)], end: [Fun

Gopal Dutt Over a year ago

result print this type of object. how I retrieve rows from that

Collectives™ on Stack Overflow

How set a value within connection.query function nodejs

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related