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

Reply via email to