if auth.is_logged_id(): db.projectfile.projectname.requires=IS_IN_DB(db (db.project.userid==auth.user.id),'project.pname','%(pname)s')
else you do not have a user id. why are you still on 1.62? ;-) On Jun 9, 9:34 am, pk <[email protected]> wrote: > thanks but i get a now an error: > Traceback (most recent call last): > File "gluon/restricted.py", line 98, in restricted > File "/Applications/web2py1.62/web2py.app/Contents/Resources/ > applications/2busy/models/db.py", line 104, in <module> > AttributeError: 'NoneType' object has no attribute 'id' > > ######################################################################### > ## Tabelle File > ######################################################################### > db.define_table('projectfile', > SQLField('userid', default=auth.user.id if auth.user > else 0, writable=False, readable=False), > SQLField('procreator', default=auth.user.last_name if > auth.user else 0, writable=False, readable=False), > SQLField('projectname'), > SQLField('filename'), > SQLField('format'), > SQLField('cdate', 'date', default=now), > SQLField('datei','upload'), > SQLField('description','text')) > > db.projectfile.projectname.requires=IS_IN_DB(db > (db.project.userid==auth.user.id),'project.pname','%(pname)s') > db.projectfile.procreator.requires=IS_IN_DB(db,'auth_user.last_name') > db.projectfile.userid.requires=IS_IN_DB(db,'auth_user.id') > db.projectfile.filename.requires=[IS_NOT_EMPTY()] > db.projectfile.format.requires=[IS_NOT_EMPTY()] > db.projectfile.cdate.requires=[IS_NOT_EMPTY(), IS_DATE()] > db.projectfile.datei.requires=IS_NOT_EMPTY() > > On 9 Jun., 16:25, mdipierro <[email protected]> wrote: > > > There is a reference to project.pname that I do not underastand so I > > can only give you a partial answer. > > > You want to specify a filter as first argument of IS_IN_DB > > > db.projectfile.projectname.requires=IS_IN_DB(db > > (db.project.userid==auth.user.id), > > 'project.pname', '%(pname)s') > > > On Jun 9, 7:01 am, pk <[email protected]> wrote: > > > > Hi, > > > > I've another question: > > > Every user should upload files and i create a table called > > > projectfile. > > > > db.define_table('projectfile', > > > SQLField('userid', default=auth.user.id if auth.user > > > else 0, writable=False, readable=False), > > > SQLField('procreator', default=auth.user.last_name if > > > auth.user else 0, writable=False, readable=False), > > > SQLField('projectname'), > > > SQLField('filename'), > > > SQLField('format'), > > > SQLField('cdate', 'date', default=now), > > > SQLField('datei','upload'), > > > SQLField('description','text')) > > > > db.projectfile.procreator.requires=IS_IN_DB(db,'auth_user.last_name') > > > db.projectfile.userid.requires=IS_IN_DB(db,'auth_user.id') > > > db.projectfile.projectname.requires=IS_IN_DB(db,'project.pname') > > > db.projectfile.filename.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB > > > (db,'projectfile.filename')] > > > db.projectfile.format.requires=[IS_NOT_EMPTY()] > > > db.projectfile.cdate.requires=[IS_NOT_EMPTY(), IS_DATE()] > > > db.projectfile.datei.requires=IS_NOT_EMPTY() > > > > -------------------------------------------------------------------------------------------------------------------------------------------- > > > > def projectfile(): > > > if auth.is_logged_in(): > > > form=SQLFORM(db.projectfile,fields=['projectname', > > > 'filename', > > > 'format', > > > 'description', > > > 'datei']) > > > > -------------------------------------------------------------------------------------------------------------------------------------------- > > > > now my question: how can i show on the website in the field > > > 'projectname' only the projects from the user not all projects in the > > > table? > > > > thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
