Query from MySQL's database returns [Object] [Object] in node.js and JSON.stringify() do not seem to work

Question

I am using MySQL database and have created table that stores user's characters names from my Discord Bot.

I want my bot to display this list on Discord after using command, but it just returns [object Object].

I tried JSON.stringify() but it doesn't work. Is there something more to it I don't know about?

con.query (`SELECT Name FROM ${message.author.username}list`, (err, rows) => {
         if(err) throw err;

         JSON.stringify(rows);
         message.reply(rows);

Both with and without stringify result are as in the picture]

As a sidenote, your code is vulnerable to a SQL injection attack. — VLAZ
– VLAZ, Commented Sep 29, 2019 at 11:47

mohammad javad ahmadi · Accepted Answer · 2019-09-29 12:23:53Z

1

you should save rows data in some variable. after update you code:

con.query (`SELECT Name FROM ${message.author.username}list`, 
            (err, rows, fields) => {
                  if(err) throw err;
                  rows = JSON.stringify(rows);
                  message.reply(rows);
}

answered Sep 29, 2019 at 12:23

mohammad javad ahmadi

2,0811 gold badge14 silver badges28 bronze badges

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

2 Comments

Shinneru Over a year ago

I've tought I tried this already, but apparently not and it works like a charm, thanks! If I may ask one more question: It works perfectly and displays: {"Name":"X"} Is there a way to display only value of that row, so for instance to display only "X" without "Name:"?

mohammad javad ahmadi Over a year ago

Thanks, Yes there is. You need to process it before stringing that object (by looping or modules used to process objects) then put all the values into an array, for example, and send the array .

Collectives™ on Stack Overflow

Query from MySQL's database returns [Object] [Object] in node.js and JSON.stringify() do not seem to work

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related