Re: [web2py] Another DAL question

Yes, prior to that, I have tried using *db.bins.tags_id*, but it returns the db entry raw, which is:* |1|2|6|8|* I would like it to return a list instead. I have also looked up older posts on nested selects, but nothing is working so far. I have tried: tags = db()._select(db.bins.tags_id) rows

Re: [web2py] Another DAL question

Il 15/10/2012 16:40, lyn2py ha scritto: > My code: > | > rows = db(db.bins.id >1).select( > left=db.notes.on( > (db.notes.tags_id.contains((*db.bins.tags_id*).split('|')) ) > ) > | > what about: | rows = db(db.bins.id>1).select( left=db.notes.on( (db.bins

Re: [web2py] Another DAL question

Thanks Manuele, the chapter has some basics of how it works, which I have already incorporated into my example. Still need help on this. Thanks! On Monday, October 15, 2012 9:59:44 PM UTC+8, Manuele wrote: > > Il 15/10/2012 11:19, lyn2py ha scritto: > > The field (*db.bins.tags_id*) has conten

Re: [web2py] Another DAL question

Il 15/10/2012 11:19, lyn2py ha scritto: The field (*db.bins.tags_id*) has contents of a list:reference type, i.e. *|1|2|6|8|* I need to get it into a list (i.e. *[1,2,6,8]*) to be used in a DAL .select(). How should I do this? My code: | rows = db(db.bins.id>1).select( left=db.notes.