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