current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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..

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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

client.query('…', function(err, result) {
  done();
  res.send(result);
});
share|improve this answer
    
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.. –  Subburaj Dec 12 '13 at 9:42
    
+1 for your valuable time.. –  Subburaj Dec 12 '13 at 11:48

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.