Hi.

You need to define the type of the field, the IS_DATE is only a
validator that will check the values before insert/update.

Use:
db.define_table('users',
    SQLField('dob', 'date',requires=IS_DATE()),

regards
mmlado

On Wed, Jun 3, 2009 at 4:36 PM, durga <durgaprasadmoga...@gmail.com> wrote:
>
> Hi,
>
> i have defined a date field in my table.
> db.define_table('users',
>                      SQLField('dob',requires=IS_DATE()),
>
> when i click on db.users in database administration. its throwing
> below error.
>
>
> Error traceback
> 1.2.3.4.5.6.7.8.9.10.11.12. Traceback (most recent call last):  File
> "C:\Apps\web2py_src\gluon\restricted.py", line 98, in restricted
> exec ccode in environment  File "C:/Apps/web2py_src/applications/
> whosay/views/appadmin.html", line 112, in <module>  File "C:\Apps
> \web2py_src\gluon\sqlhtml.py", line 645, in __init__    r = str
> (field.formatter(r))  File "C:\Apps\web2py_src\gluon\sql.py", line
> 1658, in formatter    value = item.formatter(value)  File "C:\Apps
> \web2py_src\gluon\validators.py", line 1409, in formatter    return
> value.strftime(str(self.format))AttributeError: 'str' object has no
> attribute 'strftime'
>
> thanks
> durga

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" 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