Unable to do find using variable in query

Question

I was working on a project on windows on NodeJS.

I used the following code for checking login credentials. It was working fine till I changed to ubuntu 16.04 .

I set up my environment and now the variables are not being treated as strings.

It's returning empty set from the DB. If I do it like this user_name:"some user name",password:"some password", it's working fine.

Please help. I am stuck bad :-( sorry if its a noob type mistake :-)

app.post('/login', function(req, res, next) {
    var N1 = req.body.N1;
    var N2 = req.body.N2;
    console.log(N1+N2);//Getting passed successfully
    MongoClient.connect(url, function(err, db) {
        if (err) {
            throw err;
            console.log("into connectivity error");
        }
        console.log(N1);
        db.collection('col.login').find({user_name:N1,pass:N2}).toArray(function(err, result) {
            if (err) {
                throw err;
            }
            resultArray=result;
            try{
                req.session.userId = result[0]._id;
                req.session.userType = result[0].type;
                req.session.userComp = result[0].comp_id;
                req.session.cat = -1;
                if(result[0].type=="root") {
                    res.redirect('/New_Company');
                }

database structure:

{
    "_id" : ObjectId("xxxxxxxxxxxxxxxxxxx"),
    "user_name" : "xxxxxxx",
    "pass" : "xxxxx",
    "type" : "root",
    "email" : "[email protected]",
    "comp_name" : "NULL",
    "default_page" : "main",
    "name" : "xxxxx",
    "comp_id" : "NULL"
}

i checked both N1 and N2 they are what i posted from the login page — sidd
– sidd, Commented Jun 7, 2016 at 7:58
Not sure why it is not working. Can you try doing toString() for N2 and N1 and see if it is working? — Shrabanee
– Shrabanee, Commented Jun 7, 2016 at 8:05

Shrabanee · Accepted Answer · 2016-06-07 08:21:45Z

1

Do the following way :-

app.post('/login', function(req, res, next) {
var N1 = (req.body.N1).toString();//Do toString()
var N2 = (req.body.N2).toString();
console.log(N1+N2);//Getting passed successfully
MongoClient.connect(url, function(err, db) {
    if (err) {
        throw err;
        console.log("into connectivity error");
    }
    console.log(N1);
    db.collection('col.login').find({user_name:N1,pass:N2}).toArray(function(err, result) {
        if (err) {
            throw err;
        }
        resultArray=result;
        try{
            req.session.userId = result[0]._id;
            req.session.userType = result[0].type;
            req.session.userComp = result[0].comp_id;
            req.session.cat = -1;
            if(result[0].type=="root") {
                res.redirect('/New_Company');
            }
      });

Refer toString for more info on toString().

answered Jun 7, 2016 at 8:21

Shrabanee

2,7861 gold badge21 silver badges32 bronze badges

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

1 Comment

sidd Over a year ago

Thanks for the answer.

Collectives™ on Stack Overflow

Unable to do find using variable in query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related