On Mon, Jan 3, 2011 at 5:13 PM, pk <peter.kirch...@youngdesigners.de> wrote:
> hi together, > > i have a function for the onlineuser: > > usersall=db(db.online.last_visit>time.time()-dt) (db.online.user_id==db.auth_user.id).select(db.auth_user.ALL) > This line should be : db(db.online.user_id==db.auth_user.id).select(db.auth_user.ALL) return TABLE(*[TD(user.user_name) for user in usersall]) > > but i will to get all the onlineuser which are friends of mine. > here is my friendsdatabasetable: > > ######################################################################### > ## Tabelle Freunde > ######################################################################### > db.define_table('friends', > SQLField('userid', > default=auth.user.id if auth.user else 0, > writable=False, readable=False), > SQLField('hauptperson', > default=auth.user.user_name if auth.user else > 0, > writable=False, readable=False, > label='Hauptperson'), > SQLField('freund', label='Freund'), > SQLField('freundseit', 'datetime', > default=request.now, label='Freund seit'), > SQLField('bestaetigt','boolean', default=False)) > > db.friends.userid.requires=IS_IN_DB(db,'auth_user.id') > db.friends.hauptperson.requires=IS_IN_DB(db,'auth_user.user_name') > db.friends.freund.requires=IS_IN_DB(db,'auth_user.user_name') > > how can i get this list and how can i do the name clickable??? > > thanks for your help > > peter