I see. I think what you are seeing is due to a bug. I have fixed this bug but I do not recall if it is fixed in only in trunk or also in 1.76.5. Which web2py version do you use?
Massimo On Mar 28, 6:18 pm, Avik Basu <avikb...@gmail.com> wrote: > I dropped all the records in the table and still get the same result. > I replaced the previous represent with: > > represent = lambda x: type(x) > > which shows that the records are in fact of type datetime as opposed > to string. could the issue be in the rendering of tables in appadmin? > > Avik > > On Mar 28, 6:02 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > It is possible you chaged the type of this field from 'string' to > > 'datetime' and because sqlite does not support migrations, you may > > have still string data in the datetime field. I suggest you delete > > those records that contain corrupted data. > > > Massimo > > > On Mar 28, 4:54 pm, Avik Basu <avikb...@gmail.com> wrote: > > > > I would like to use the represent function on a datetime object, like > > > so: > > > > from datetime import * > > > > db.define_table("adate", > > > Field("date","datetime", > > > represent = lambda x: x.strftime("%a %m-%d-%y") if x else 'No > > > time' #convert datetime object to string > > > ) > > > ) > > > > This works when I create a form, however when i use appadmin it gives > > > the following error: > > > > Traceback (most recent call last): > > > File "gluon/restricted.py", line 173, in restricted > > > File "/Applications/web2py.app/Contents/Resources/applications/ > > > FWv7_7/views/appadmin.html", line 196, in <module> > > > File "gluon/sqlhtml.py", line 1103, in __init__ > > > File "gluon/sql.py", line 2676, in formatter > > > File "gluon/validators.py", line 2006, in formatter > > > AttributeError: 'str' object has no attribute 'strftime' > > > > Avik -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.