Rethrow non-MySQL errors Node.js

Question

Hi the code below loads a single field from a mysql database, but when it gets to the point result[0].IdUtente the error below is generated. How do I solve it?

ERROR:

 throw err; // Rethrow non-MySQL errors
        ^

TypeError: Cannot read property 'IdUtente' of undefined

CODE:

var query = "SELECT IdUtente FROM Utente WHERE Username = " + sql.escape(Username) + " and Password=MD5(" + sql.escape(Password) + ") and Tipo!='Risorsa' ";
var ret=DbConfig.query(query, function (err, result) {
    if (err) {
        console.log("Errore login: " + err);
    }
    else {
        console.log(result[0].IdUtente);
        IdUtente = result[0].IdUtente;

    }

});

I was getting the same error. Realized that it was due to incorrect SQL syntax. Make sure that you are writing the correct SQL as well. — Pranav Soni
– Pranav Soni, Commented Apr 13, 2021 at 23:27

Aslam · Accepted Answer · 2019-01-21 16:24:48Z

4

This error occur when the query pulls an empty result. You must first check the length of result with result.length property, only if the result is greater than 0 you must use index the result. Please check the code below.

var query = "SELECT IdUtente FROM Utente WHERE Username = " + sql.escape(Username) + " and Password=MD5(" + sql.escape(Password) + ") and Tipo!='Risorsa' ";
var ret=DbConfig.query(query, function (err, result) {
    if (err) {
        console.log("Errore login: " + err);
    }
    else {
        //check to see if the result is empty
        if(result.length > 0){
            console.log(result[0].IdUtente);
            IdUtente = result[0].IdUtente;
       }
    }
});

answered Jan 21, 2019 at 16:24

Aslam

7711 gold badge10 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

Rethrow non-MySQL errors Node.js

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