Variable into mongodb query

Question

ok this is driving me crazy..

function(amount){

matchingOrder = Order.findOne({
        Price: {
          $lte: amount
        }
      }, {
        sort: {
          Price: 1,
          Order_ID: 1
        }
      });

}

-----does not work

this works:

function(){

amount = 2

matchingOrder = Order.findOne({
        Price: {
          $lte: amount
        }
      }, {
        sort: {
          Price: 1,
          Order_ID: 1
        }
      });

}

in both cases console.log(amount) is 2 so variable gets passed

...sorry for maybe obvious scope or something..im relativly new at this

How are you calling this? It is an anon function so maybe there is a problem in how you are assigning its parameter? — Sammaye
– Sammaye, Commented Mar 10, 2014 at 14:53
Maybe weird case of semicolon insertion? Try inserting semicolon after amount = 2 just to be sure...and use var while you are at it, if the variable is not defined with var somewhere else. — Capaj
– Capaj, Commented Mar 10, 2014 at 14:53

Emilio Rodriguez · Accepted Answer · 2014-03-10 14:48:24Z

1

The only thing coming to my mind could be different types for amount. Try this instead:

function(amount){

matchingOrder = Order.findOne({
        Price: {
          $lte: parseInt(amount)
        }
      }, {
        sort: {
          Price: 1,
          Order_ID: 1
        }
      });

}

answered Mar 10, 2014 at 14:48

Emilio Rodriguez

5,7494 gold badges29 silver badges32 bronze badges

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

1 Comment

Capaj Over a year ago

It is better to check the type at the beginning, because like this if parseInt returns NaN and you execute the query, you waste your DB's time on useless query.

Morrisda · Accepted Answer · 2014-03-10 14:53:24Z

0

function query_am(input){

 var amount = input; //pay attention, as pre-condition your input must be a number.

 matchingOrder = Order.findOne({
    Price: {
      $lte: amount
    }
  }, {
    sort: {
      Price: 1,
      Order_ID: 1
    }
  });

}

To invoke this function, for example: query_am(2) or query_am(6) . don't do query_am('6')

answered Mar 10, 2014 at 14:53

Morrisda

1,4221 gold badge12 silver badges26 bronze badges

1 Comment

Capaj Over a year ago

for checking if number is indeed a number, check out this spectacular answer: stackoverflow.com/a/1830844/671457

Collectives™ on Stack Overflow

Variable into mongodb query

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related