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 : <h2>Companies</h2> <table> <h2>New Film</h2> {{=form1}} <br> <h2>Film edit</h2> {{=form2}} <br> {{for Film in films:}} <tr> <td>{{=A(Film.Nom)}}</td> <td>{{=A('edit', _href=URL('admindanakFilm', args=Film.id))}}</td> </tr> {{pass}} <tr> <td></td> </tr> </table> and it gave to me : 127.0.0.1.2012-03-17.14-33-40.9b6207b2-aaf8-4dec-8c10-a4321f3616aa <type 'exceptions.KeyError'> '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" <http://127.0.0.1:8000/admin/default/edit/init/controllers/default.py>, line 96, in <module> File "gluon/globals.py", line 173, in <lambda> File "C:/Users/Bussiere/Dropbox/Projets/danak/web2py/applications/init/controllers/default.py" <http://127.0.0.1:8000/admin/default/edit/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__