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 -~----------~----~----~----~------~----~------~--~---