I got a table for articles which contains an ids of users which commented
on that particular image.
now I like to read all the user ids of an particular aricle and display a
list off all articles those users commented on.
here is my first attempt: but its pretty aweful:
db.define_table('Article',
Field('Title'),
Field('content','blob'),
Field('Users','list:reference auth_user'),
Field('Submitted','datetime',default=datetime.datetime.now(),writable=False,readable=False)
)
model:
def displaylist():
id=request.vars.id
row=db(db.Articles.id==id).select()
row=row[0]
Userids=row.Users
related=[]
for i in Userids:
related.append(db().select(db.Articles.User,i))
return dict(originalArticle=row,related=related)
view:
{{for i in related:}}
{{#=some funky select}}
{{pass}}
--