'user', 'type' and 'timestamp' are reserved keywords in many SQL
dialects
On Feb 26, 11:35 pm, weheh <richard_gor...@verizon.net> wrote:
> Indeed, the problem now appears to not be with auth at all. The
> problem seems to be with the create() function statement:
>
> form=SQLFORM(db.objects,fields=['type','name','description'])
>
> Any idea what might be at fault here?
>
> My model for the object is:
>
> db.define_table('object',
> SQLField('user',db.auth_user),
> SQLField('left','integer'),
> SQLField('right','integer'),
> SQLField('type','string'),
> SQLField('name','string'),
> SQLField('description','text'),
> SQLField('ignore','boolean'),
> SQLField('timestamp','datetime',default=now)
> )
> db.object.user.requires=IS_IN_DB(db,'auth_user.id','%(email)s')
> db.object.name.requires=IS_NOT_EMPTY(
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---