return null value in node.js?

Question

I am new in nodejs. Here is my code in nodejs file. i want to send data from nodejs to other javascript use json.stringify,but my problem is i get null value... ----------------EDIT-----------------------

my code is

function handler ( req, res ) {
        calldb(dr,ke,function(data){
            console.log(data); //successfully return value from calldb                                      
        });
    //i think my problem bellow...
    res.write( JSON.stringify(data)); //send data to other but it's null value
    res.end('\n');
}

function calldb(Dr,Ke,callback){
    // Doing the database query
    query = connection.query("select id,user from tabel"),
        datachat = []; // this array will contain the result of our db query
    query
    .on('error', function(err) {
        console.log( err );
    })
    .on('result', function( user ) {
        datachat.push( user );
    })
    .on('end',function(){
        if(connectionsArray.length) {
            jsonStringx = JSON.stringify( datachat );
            callback(jsonStringx); //send result query to handler
        }
    });

}

How to fix this problem?

Barış Uşaklı · Accepted Answer · 2013-05-04 14:10:26Z

6

You will need to use callbacks, returning data directly will just return null because the end event handler is called later when all the data is ready. Try something like :

function handler ( req, res ) {
    calldb(dr, ke, function(data){
       console.log(data);
       res.write( JSON.stringify(data)); 
       res.end('\n');
    });
}

function calldb(Dr,Ke, callback) { 

    var query = connection.query('SELECT id,userfrom tabel'),
        datachat= []; // this array will contain the result of our db query

    query
     .on('error', function(err) {
        console.log( err );
     })
     .on('result', function( user ) {
        datachat.push( user );
     })
     .on('end',function() {
        callback(datachat);
    }); 

}

edited May 4, 2013 at 14:10

answered May 4, 2013 at 3:50

Barış Uşaklı

13.5k7 gold badges44 silver badges69 bronze badges

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

2 Comments

ltvie Over a year ago

Thanks..i follow your code,but i get error 'string is not function'..how to fix this?

ltvie Over a year ago

my problem was fix,but i get null value again when i send value in other function...see edit (i change my code)

V31 · Accepted Answer · 2013-05-04 13:33:29Z

1

The problem is that nodejs is asynchronous. It will execute your res.write( JSON.stringify(data)); before your function will be called. You have two options: one to avoid callback:

    .on('end',function(){
      if(connectionsArray.length) {
        jsonStringx = JSON.stringify( datachat );
        res.write( JSON.stringify(data)); 
        res.end('\n');
      }
    }

the other have the response in the callback function like this:

function boxold() {
  box(function(data) {
        res.write( JSON.stringify(data)); 
        res.end('\n');
        //console.log(data);
  });
}

answered May 4, 2013 at 13:33

V31

7,6643 gold badges28 silver badges44 bronze badges

Collectives™ on Stack Overflow

return null value in node.js?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related