0
client.query("select * from rooms where token = ?", [data.token], function(err, results, fields) {
 callback(results);
 console.log(results); 
});

This is a query that returns the result as an array. How can I get the necessary fields?

asasdasd
  • 1
  • What does console.log(results) return? Have you tried results.field1, results.field2 etc? – Raoul George Aug 10 '13 at 15:43
  • console.log(results) return: [ { bump: 1376149484, user: 'alex', token: 11569, active: 0 } ] results.field1, results.field2 return "null" – asasdasd Aug 10 '13 at 15:53
  • possible duplicate of [Access / process (nested) objects, arrays or JSON](http://stackoverflow.com/questions/11922383/access-process-nested-objects-arrays-or-json) – bfavaretto Aug 10 '13 at 15:56

1 Answers1

0

Looking at your comment, if the json object is -:

[
   {
      "bump":"1376149484",
      "user":"alex",
      "token":"11569",
      "active":0
   }
]

You can iterate through the object like so -:

for (var i in results)
{
  console.log('bump = ' + results[i].bump);
  console.log('user = ' + results[i].user);
  console.log('token = ' + results[i].token);
  console.log('active = ' + results[i].active);
}
Raoul George
  • 2,807
  • 1
  • 21
  • 25