How to properly return a result from mysql with Node?

by

You’re going to need to get your head around asynchronous calls and callbacks with javascript, this isn’t C#, PHP, etc…

Here’s an example using your code:

function get_info(data, callback){
      
      var sql = "SELECT a from b where info = data";

      connection.query(sql, function(err, results){
            if (err){ 
              throw err;
            }
            console.log(results[0].objid); // good
            stuff_i_want = results[0].objid;  // Scope is larger than function

            return callback(results[0].objid);
    })
}


//usage

var stuff_i_want="";

 get_info(parm, function(result){
    stuff_i_want = result;

    //rest of your code goes in here
 });

When you call get_info this, in turn, calls connection.query, which takes a callback (that’s what function(err, results) is
The scope is then passed to this callback, and so on.

Welcome to javascript callback hell…

It’s easy when you get the hang of it, just takes a bit of getting used to, coming from something like C#

More Related Contents:

  1. How to send documents from my mongodb database to android application?
  2. The difference between “require(x)” and “import x”
  3. NPM global install “cannot find module”
  4. How to include scripts located inside the node_modules folder?
  5. Command to remove all npm modules globally
  6. Comparing mongoose _id and strings
  7. Pipe a stream to s3.upload()
  8. Express.js – app.listen vs server.listen
  9. Where is body in a nodejs http.get response?
  10. Unknown events in nodejs/v8 flamegraph using perf_events
  11. How to use a variable as a field name in mongodb-native findOne()?
  12. How to solve error “SyntaxError: Unexpected token ‘?'”
  13. ReferenceError: describe is not defined NodeJs
  14. How to set npm credentials using `npm login` without reading from stdin?
  15. Mongoose indexing in production code
  16. Send custom data along with handshakeData in socket.io?
  17. GraphQL Expected Iterable, but did not find one for field xxx.yyy
  18. node.js Setup Wizard ended prematurely
  19. How to unpack an .asar file?
  20. What is the difference between addListener(event, listener) and on(event, listener) method in node.js?
  21. How to use D3 in Node.js properly?
  22. Best way to execute parallel processing in Node.js
  23. Fail to connect Mongoose to Atlas
  24. node js – what happens to incoming events during callback excution
  25. Node.js: how to limit the HTTP request size and upload file size?
  26. How can I output data before I end the response?
  27. How to send data from JQuery AJAX request to Node.js server
  28. Uploading multiple files with multer, but from different fields?
  29. socket.io private message
  30. Windows Azure Websites is overriding my 404 and 500 error pages in my node.js app

Leave a Comment