Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. results2 = [];
  2. categories2 = [];
  3.  
  4. // SQL Query > Select Data
  5. const query2 = client.query('SELECT * FROM entries ORDER BY id desc');
  6. // Stream results back one row at a time
  7. query2.on('row', (row) => {
  8. results2.push(row);
  9. });
  10. const query3 = client.query('SELECT * FROM categories ORDER BY id desc');
  11. // Stream results back one row at a time
  12. query3.on('row', (row) => {
  13. categories2.push(row);
  14. });
  15. // After all data is returned, close connection and return results
  16. query3.on('end', () => {
  17. done();
  18. return res.render('index2.ejs',{results:results2,categories: categories2});
  19. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement