mySQL query in node.js is returning undefined

Question

When making an sql query my function is returning undefined. I'm unsure how to fix this and was confused when I googled the problem. Here is a section of my code:

function randomfact() {
let sql = 'SELECT id FROM facts ORDER BY RAND() LIMIT 1;';
let query = db.query(sql, (err, result) => {
    if (err) {
        throw err;
    }
    else {
        return result;
    }
});
}

const app = express();

app.get("/", function(req, res) {
   res.send(randomfact());
   console.log(randomfact());
});

My best guess as to the issue is that I am returning an incorrect datatype but I am unsure on how to fix it.

Any advice is good advice thanks!

Eranga Heshan · Accepted Answer · 2021-06-08 00:59:20Z

4

Change your randomfact function to return the query result:

function randomfact() {
  let sql = 'SELECT id FROM facts ORDER BY RAND() LIMIT 1;';
  return new Promise((resolve, reject) => {
    db.query(sql, (err, result) => {
      if (err) {
        reject(err);
      }
      else {
        resolve(result);
      }
    });
  });
}

Wait for randomfact to return the result:

app.get("/", async function(req, res) {
   const result = await randomfact();
   res.send(result);
   console.log(randomfact());
});

answered Jun 8, 2021 at 0:59

Eranga Heshan

5,8724 gold badges31 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

mySQL query in node.js is returning undefined

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