[web2py] Re: Key error that i don't understand based on the cookbook.

2012-03-17 Thread bussiere adrien 
Found it all my db have name and one had a mystake.

Regards
Bussiere

Le samedi 17 mars 2012 14:35:30 UTC+1, bussiere adrien a écrit :
>
> here is my db.py :
>
> db.define_table('ImageFilmPreview',
>Field('Nom'),
>Field('date_Creation','date'),
>Field('Tag','list:reference Tag'),
>Field('FamilleTag','list:reference FamilleTag'),
>Field('Type','list:reference Type'),
>Field('Valeur_Ticket','double'),
>Field('Description_Courte'),
>Field('Description_Longue'),
>Field('Image'),#a revoir 
>Field('Texte_contenu','list:reference Texte_contenu'),
>Field('Link','list:reference Link'),
>Field('Note_divers','list:reference Note_divers'),
>format = '%(Nom)s')
>
>
> db.define_table('Film',
>Field('Nom'),
>Field('UrlPreview'),
>Field('date_Creation','date'),
>Field('date_Publication','date'),
>Field('Tag','list:reference Tag'),
>Field('FamilleTag','list:reference FamilleTag'),
>Field('Type','list:reference Type'),
>Field('Valeur_Ticket','double'),
>Field('Description_Courte'),
>Field('Description_Longue'),
>Field('ImageFilm','list:reference ImageFilm'),
>Field('ImageFilmPreview','list:reference ImagePreview'),
>Field('Texte_contenu','list:reference Texte_contenu'),
>Field('Acteur','list:reference Acteur'),
>Field('Avis','list:reference Avis'),
>Field('Link','list:reference Link'),
>Field('Note_divers','list:reference Note_divers'),
>format = '%(Nom)s')
>
>
> here is my default.py :
>
> def admindanakFilm():
> Line 88:form1 = crud.create(db.Film, next='admindanakFilm')
> films = db(db.Film).select(orderby=db.Film.id)
> film = db.company(request.args(0)) or redirect(URL('admindanak'))
> form2 = crud.update(db.Film, film, next='Film')
> return locals()
>
>
> and here is my template :
> Companies
> 
> New Film
> {{=form1}}
> 
> Film edit
> {{=form2}}
> 
>
> {{for Film in films:}}
> 
> {{=A(Film.Nom)}}
> {{=A('edit', _href=URL('admindanakFilm',
> args=Film.id))}}
> 
> {{pass}}
> 
> 
> 
> 
>
>
> and it gave to me :
>
> 127.0.0.1.2012-03-17.14-33-40.9b6207b2-aaf8-4dec-8c10-a4321f3616aa
>  'Nom'VERSIONweb2py™(1, 99, 7, 
> datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable')PythonPython 2.5.4: 
> C:\Users\Bussiere\Dropbox\Projets\danak\web2py\web2py.exeTRACEBACK
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
> 15.
>
> Traceback (most recent call last):
>   File "gluon/restricted.py", line 205, in restricted
>   File 
> "C:/Users/Bussiere/Dropbox/Projets/danak/web2py/applications/init/controllers/default.py"
>  , line 
> 96, in 
>   File "gluon/globals.py", line 173, in 
>   File 
> "C:/Users/Bussiere/Dropbox/Projets/danak/web2py/applications/init/controllers/default.py"
>  , line 
> 88, in admindanakFilm
>   File "gluon/tools.py", line 3172, in create
>   File "gluon/tools.py", line 3089, in update
>   File "gluon/sqlhtml.py", line 870, in __init__
>   File "gluon/sqlhtml.py", line 283, in widget
>   File "gluon/sqlhtml.py", line 216, in widget
>   File "gluon/validators.py", line 465, in options
>   File "gluon/validators.py", line 447, in build_set
>   File "gluon/dal.py", line 6714, in __getitem__
>
>

[web2py] Re: Key error that i don't understand based on the cookbook.

2012-03-17 Thread bussiere adrien 
Found it the error was not so explicit all my name film and actors was name.

Bussiere

Le samedi 17 mars 2012 14:35:30 UTC+1, bussiere adrien a écrit :
>
> here is my db.py :
>
> db.define_table('ImageFilmPreview',
>Field('Nom'),
>Field('date_Creation','date'),
>Field('Tag','list:reference Tag'),
>Field('FamilleTag','list:reference FamilleTag'),
>Field('Type','list:reference Type'),
>Field('Valeur_Ticket','double'),
>Field('Description_Courte'),
>Field('Description_Longue'),
>Field('Image'),#a revoir 
>Field('Texte_contenu','list:reference Texte_contenu'),
>Field('Link','list:reference Link'),
>Field('Note_divers','list:reference Note_divers'),
>format = '%(Nom)s')
>
>
> db.define_table('Film',
>Field('Nom'),
>Field('UrlPreview'),
>Field('date_Creation','date'),
>Field('date_Publication','date'),
>Field('Tag','list:reference Tag'),
>Field('FamilleTag','list:reference FamilleTag'),
>Field('Type','list:reference Type'),
>Field('Valeur_Ticket','double'),
>Field('Description_Courte'),
>Field('Description_Longue'),
>Field('ImageFilm','list:reference ImageFilm'),
>Field('ImageFilmPreview','list:reference ImagePreview'),
>Field('Texte_contenu','list:reference Texte_contenu'),
>Field('Acteur','list:reference Acteur'),
>Field('Avis','list:reference Avis'),
>Field('Link','list:reference Link'),
>Field('Note_divers','list:reference Note_divers'),
>format = '%(Nom)s')
>
>
> here is my default.py :
>
> def admindanakFilm():
> Line 88:form1 = crud.create(db.Film, next='admindanakFilm')
> films = db(db.Film).select(orderby=db.Film.id)
> film = db.company(request.args(0)) or redirect(URL('admindanak'))
> form2 = crud.update(db.Film, film, next='Film')
> return locals()
>
>
> and here is my template :
> Companies
> 
> New Film
> {{=form1}}
> 
> Film edit
> {{=form2}}
> 
>
> {{for Film in films:}}
> 
> {{=A(Film.Nom)}}
> {{=A('edit', _href=URL('admindanakFilm',
> args=Film.id))}}
> 
> {{pass}}
> 
> 
> 
> 
>
>
> and it gave to me :
>
> 127.0.0.1.2012-03-17.14-33-40.9b6207b2-aaf8-4dec-8c10-a4321f3616aa
>  'Nom'VERSIONweb2py™(1, 99, 7, 
> datetime.datetime(2012, 3, 4, 22, 12, 8), 'stable')PythonPython 2.5.4: 
> C:\Users\Bussiere\Dropbox\Projets\danak\web2py\web2py.exeTRACEBACK
>
> 1.
> 2.
> 3.
> 4.
> 5.
> 6.
> 7.
> 8.
> 9.
> 10.
> 11.
> 12.
> 13.
> 14.
> 15.
>
> Traceback (most recent call last):
>   File "gluon/restricted.py", line 205, in restricted
>   File 
> "C:/Users/Bussiere/Dropbox/Projets/danak/web2py/applications/init/controllers/default.py"
>  , line 
> 96, in 
>   File "gluon/globals.py", line 173, in 
>   File 
> "C:/Users/Bussiere/Dropbox/Projets/danak/web2py/applications/init/controllers/default.py"
>  , line 
> 88, in admindanakFilm
>   File "gluon/tools.py", line 3172, in create
>   File "gluon/tools.py", line 3089, in update
>   File "gluon/sqlhtml.py", line 870, in __init__
>   File "gluon/sqlhtml.py", line 283, in widget
>   File "gluon/sqlhtml.py", line 216, in widget
>   File "gluon/validators.py", line 465, in options
>   File "gluon/validators.py", line 447, in build_set
>   File "gluon/dal.py", line 6714, in __getitem__
>
>