node js mysql accessing javascript object

Question

I am querying a db from Node.JS I am trying to get access to the content of the FileContent field in CodeFile, it returns a Javascript object: result.

jsUpdateCon.query('SELECT FileContent FROM codeFile WHERE ID = ?',[msg[1]], function(err, result){
if (err) throw err;
console.log('Data received from DB:\n');
    console.log(result);
});

console output: [ RowDataPacket { FileContent: 'someContent' } ]

if I try console.log(result.RowDataPacket); I get

console output: undefined

if I try console.log(result.RowDataPacket.FileContent);

The entire node crashes with

TypeError: Cannot read property 'FileContent' of undefined

my ultimate goal would be to get

console output: someContent when using console.log(result.something.something)

What am I doing wrong?

madox2 · Accepted Answer · 2016-02-25 21:32:13Z

4

It looks like the result is an array, try to access it like this:

console.log(result[0].FileContent)

answered Feb 25, 2016 at 21:32

madox2

52.3k21 gold badges106 silver badges101 bronze badges

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

Collectives™ on Stack Overflow

node js mysql accessing javascript object

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related