how to render multiple collections data to page in node js from mongodb

Question

I am having problems rendering multiple collection to page.I have done a lot of research but getting an error like Failed to look up view in views directory my code is following

router.get('/', function(req, res, next) {
MongoClient.connect(url, function (err, db) {
if (err) {
        console.log('Unable to connect to the mongoDB server. Error:', err);
} else {
db.collection('book', function(err, collection1) {
collection1.find().toArray(function(err, items) {
db.collection('category', function(err, collection) {
collection.find().toArray(function(err, citems) {
res.send('pages/home', {title:'Express',itm:items,citm:citems});
});
});
});
});
 }
});

vmkcom · Accepted Answer · 2015-11-19 10:10:01Z

1

the problem with your view location, it's cannot be found by path pages/home

Try to debug this first and don't think about mongodb now. But if you want to debug mongodb queries - just log into console your items and citems

answered Nov 19, 2015 at 10:10

vmkcom

1,67812 silver badges17 bronze badges

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

5 Comments

Narendra Sharma Over a year ago

i am getting items and citems afer printing them in console but when i pass them in page to render values i get page views look up error

Narendra Sharma Over a year ago

console.log(items,citems) // res.render('./pages/home', { title: 'Express',itm:items,citm:citems}); it works if i uncomment it but not able to render it to page

vmkcom Over a year ago

show your files structure tree and where you initialize view engine for express. Something with your pathes

Narendra Sharma Over a year ago

i have attached an image showing file structure. i have used ejs engine to show views templates

vmkcom Over a year ago

ok, @NarendraSharma, the problem is with view named 'error', cause your request generatin error and express trying to lookup 'error.ejs'. Maybe problem inside your home.ejs structure or code. Try to delete all content from home.ejs and look at the backend logs, if it's generating error or not

Ketha Kavya · Accepted Answer · 2015-11-19 12:57:42Z

1

In app.js you can set the views to view like this:

app.set('views', [__dirname + 'views', __dirname + 'views/pages']);

and your response to:

res.render('home',{title:'Express',itm:items,citm:citems});

edited Nov 19, 2015 at 12:57

answered Nov 19, 2015 at 12:34

Ketha Kavya

5886 silver badges18 bronze badges

2 Comments

Ketha Kavya Over a year ago

once try creating error.ejs file in your views directory instead or error.jade.

Narendra Sharma Over a year ago

i tried creating error.ejs but still getting the same error msg

user3658423 · Accepted Answer · 2015-11-19 10:11:25Z

0

try this (I am assuming you are using express.js and jade)

res.render('./pages/home', {title:'Express',itm:items,citm:citems});

answered Nov 19, 2015 at 10:11

user3658423

1,9446 gold badges30 silver badges52 bronze badges

1 Comment

Narendra Sharma Over a year ago

no luck big bro . i am still getting an error it works great by doing so but not when uncommenting render page console.log(items,citems) // res.render('./pages/home', { title: 'Express',itm:items,citm:citems});

Ajith Pai · Accepted Answer · 2015-11-20 04:41:21Z

0

In app.js, please add the following piece of code,

app.set('views', path.join(__dirname, 'views'));
app.engine('html', require('ejs').renderFile);
app.set('view engine', 'ejs');

Hope this helps, Thanks..!

answered Nov 20, 2015 at 4:41

Ajith Pai

345 bronze badges

Collectives™ on Stack Overflow

how to render multiple collections data to page in node js from mongodb

4 Answers 4

5 Comments

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related