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 <[email protected]> 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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---