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}}

-- 



Reply via email to