node.js + postgres data Arrangement

Question

I am new to this node.js and postgres database. I have done everything perfect querying and getting result. My problem is that when I am running select query in pgAdmin I am getting some 100 rows as output..

My code:

app.get('/reconcile', function(req, res){

var villagename = req.query.query;
var village=name.substring(0,4);
console.log("sub="+village);
console.log("select * from xxxxxxxxx where level4 ILIKE '%"+village+"%'")
   var  query = client.query("select * from tn_village where level4 ILIKE '%"+village+"%'");
   query.on('row', function(rows) {  
   res.send(rows);
});
});

What i want to achieve is .Suppose consider i am searching for "Apple" i am getting words matching "APP" form database by using above(Like) command..Now its showing json as alphabetical order..I want to display json as highest to lowest matching data in Json..

Help me to achieve this..Thanks in advance..

ckruse · Accepted Answer · 2013-12-12 08:34:25Z

1

query.on('row', …) executes the callback for every row. Use

client.query('…', function(err, result) {
  done();
  res.send(result);
});

answered Dec 12, 2013 at 8:34

ckruse

9,7701 gold badge27 silver badges25 bronze badges

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

1 Comment

Subburaj Over a year ago

Thanks @ckruse..Its working..But i am facing other problem.. 1)Its returning json for all rows and also printing fields and parsers..I don't want that..I have to display only the rows.. 2)Also How can i remove the files with null value..

Collectives™ on Stack Overflow

node.js + postgres data Arrangement

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