Thank you for the answer..Yes I think probably is format = '%(partenza)s,%(partenza)s' I am at the end of the program and this was a bad problem. Thank you very much this forum is good
On Saturday, 7 November 2015 02:46:32 UTC+1, DenesL wrote: > > Without trying out the code I think the problem is the invalid format > string. > format = '%(partenza,partenza)s' > > In a format string each variable is formatted separately as in > format = '%(partenza)s,%(partenza)s' > > Look up "String Formatting Operations" in the Python manual for full > details. > > By the way, these lines are duplicated in your code > db.esercizio_consorzio.id.readable = False > db.esercizio_consorzio.id.writable = False > > maybe you want the second set to be > db.esercizio.id.readable = False > db.esercizio.id.writable = False > > > Denes > > On Friday, November 6, 2015 at 5:40:13 AM UTC-5, Alessio Varalta wrote: >> >> Hi I have two table and I don't understand because I received a error >> when I enter in appadmin/esercizio...I use sqlite and I try to download the >> Csv of esercizio table and the csv is correct..the application work fine, >> but when I try to enter esercizio I received this error(see below the >> table)..Thanks in advance, I have no idea >> >> db.define_table('esercizio_consorzio', >> >> Field('partenza',type='date',requires=IS_DATE(str(T('%d-%m-%Y')))), >> >> Field('finale',type='date',requires=IS_DATE(str(T('%d-%m-%Y')))), >> Field('stato',type='boolean',requires=IS_NOT_EMPTY()), >> format = '%(partenza,partenza)s' >> >> ) >> db.esercizio_consorzio.id.readable = False >> db.esercizio_consorzio.id.writable = False >> >> >> >> db.define_table('esercizio', >> Field('inviato',type='boolean',requires=IS_NOT_EMPTY()), >> Field('user_id','reference >> auth_user',requires=IS_NOT_EMPTY(),readable=False,writable=False), >> Field('esercizio_consorzio','reference >> esercizio_consorzio',requires=IS_NOT_EMPTY(),readable=False,writable=False), >> >> ) >> db.esercizio_consorzio.id.readable = False >> db.esercizio_consorzio.id.writable = False >> >> Traceback (most recent call last): >> File "/home/www-data/web2py/gluon/restricted.py", line 227, in restricted >> exec ccode in environment >> File "/home/www-data/web2py/applications/coop/views/appadmin.html" >> <https://136.243.247.71/admin/default/edit/coop/views/appadmin.html>, line >> 191, in <module> >> {{pass}} >> File "/home/www-data/web2py/gluon/sqlhtml.py", line 3252, in __init__ >> r = A(represent(field, r, record), _href=str(href)) >> File "/home/www-data/web2py/gluon/sqlhtml.py", line 68, in represent >> return f(value) >> File "/home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py", >> line 265, in __call__ >> return value if value is None else _fieldformat(self.ref, value) >> File "/home/www-data/web2py/gluon/packages/dal/pydal/helpers/methods.py", >> line 253, in _fieldformat >> return r._format % row >> File "/home/www-data/web2py/gluon/packages/dal/pydal/objects.py", line 76, >> in __getitem__ >> raise KeyError >> KeyError >> >> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.