I am querying potgres in javascript. I passing string as a parameter but getting empty resultset. I have tried even using lodash toString method to no avail. however when I run the query in pgadmin i get a record.
User.getIdByPhone = function (phone, callback){
if(!phone) return;
email = _.toString(phone);
pg.query('SELECT id FROM users WHERE phone = $1', [phone], function (err, results) {
if (err){
console.log('error on UserRule: 83', err)
return callback(false, true);
}
try{
if(!_.isUndefined(results.rows[0]))
callback(results.rows[0].id, false);
else
callback(false, true)
}
catch(e){
console.log(e)
}
});
}