Hmmmm..I figured it but it was not clear....I get a group by clause and the date was a group was nested in the results....
On Aug 5, 10:12 pm, Dutch opera <dutchop...@gmail.com> wrote: > Hi, > > my query seens to work. In the shell...I run the query and I print > the results.... > > 2009-07-27,0,0,0 > 2009-07-28,0,0,0 > 2009-07-29,0,0,0 > > if I loop though each of the fields they work...expect the date > field. My mysql its stored as a datetime. > > in the shell.... > > for r in records: > print r.date > > I get this error... > > Traceback (most recent call last): > File "<console>", line 2, in <module> > File "/home/dutch/workspace/test/gluon/sql.py", line 526, in > __getattr__ > return dict.__getitem__(self,key) > KeyError: 'date' > > Why do I this this error? > > The same process works for the other columns names albeit they are not > date fields... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@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 -~----------~----~----~----~------~----~------~--~---
