images=db(db.image.blog_id==db.blogposts.id).select(db.image.ALL) Here you are saying to the database to do exactly what you don't want...
You should pass the id of your db.blogposts and not all the ids... Try : images=db(db.image.blog_id==1).select(db.image.ALL) If there is a blogposts that have id 1... You should have only the images associates to this blogposts record... Richard On Tue, Jul 26, 2011 at 12:19 PM, Web2Py Freak <halna...@gardeniatelco.com>wrote: > this is the code for adding an image to a blog : when i use it it > gets all the images to all the blogs > ........................................................... > db.py: > > > import datetime > now=datetime.datetime.today() > db.define_table('blogposts', > SQLField('title', length=64), > SQLField('author', default=session.username), > SQLField('datetime', 'datetime',default=now), > SQLField('post', 'text'), > SQLField('numcomments', 'integer',default=0)) > db.blogposts.title.requires = [IS_NOT_EMPTY(), > IS_NOT_IN_DB(db,db.blogposts.title)] > db.blogposts.author.requires = IS_NOT_EMPTY() > db.blogposts.post.requires = IS_NOT_EMPTY() > > db.define_table('image',Field('blog_id',db.blogposts),Field('title'),Field( > 'discription','text'),Field('image','upload')) > db.image.title.requires = IS_NOT_IN_DB(db, db.image.title) > db.image.blog_id.requires = IS_IN_DB(db, db.blogposts.id, '% > (title)s') > > ......................................................................... > controler: > > blogposts = db().select(db.blogposts.ALL, > orderby=~db.blogposts.datetime) > blogposts_numcomments = db().select(db.blogposts.ALL, > orderby=~db.blogposts.numcomments|~db.blogposts.datetime) > commentsnposts = db(db.blogcomments.blogpost_id == > db.blogposts.id) > comments = commentsnposts.select(db.blogcomments.author, > db.blogcomments.blogpost_id, db.blogposts.title, > orderby=~db.blogcomments.datetime) > images=db(db.image.blog_id==db.blogposts.id).select(db.image.ALL) > youtube=db(db.youtube.blog_id==db.blogposts.id).select(db.youtube.ALL) > vimo=db(db.vimo.blog_id==db.blogposts.id).select(db.vimo.ALL) > return dict(blogposts=blogposts, > blogposts_numcomments=blogposts_numcomments, > comments=comments,images=images,youtube=youtube,vimo=vimo) > > > ..................................... > > view: > > {{for photo in images:}} > <div style="width:200px ; margin-left:200px"> > <div style="width:200px;margin-left:50px"> > <p><b>{{=XML(photo.title)}}</b></p> > </div> > <img width="200px" > src="{{=URL('download', args=photo.image)}}" /> > <div style="width:200px;margin-left:50px"> > <p>{{=XML(photo.discription)}}</p> > </div> > <div> > {{pass}} >