Hi,
I had my database application up and running. I was editing some date
fields. edited one field an athen I used the ctrl and letter C to copy
some dat and used Ctrl letter V to place the changed data. I use this
method to adjust the other date fields. Then I went out and tried to
run the adminstration for the database and get and error tha indicates
tha I have an error in the fields that points back to a field
definition as
"db.person.first_name requires IS_NOT_EMPTY()"
If I delete that line, it points to the next line as an error.
I have copied the definiting out to Crimson Editor and mad mass
changes chandgin field definitions form SQLField to Field( indicated
in your manual 2nd ed) but its not that?
Is there a way I can find the undisplayed character or use a better
editor?
or what?
Thanks for any help
Jim
code is a follows
======================================================
db.define_table('specialty',Field('name'))
from gluon.tools import *
auth=Auth(globals(),db) # authentication/authorization
# the fields below are requires you can add more
db.define_table('person',
Field('first_name', length=128),
Field('middle_name', length=128,default=''),
Field('last_name', length=128,default=''),
Field('birth_date','date',default=now),
Field('death_date', 'date', label='Date of death',
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('email', length=128,default=''),
Field('web_page', length=128),
Field('is_politician', 'boolean', default=True),
Field('is_business', 'boolean', default=True),
Field('is_education', 'boolean', default=True),
Field('is_government', 'boolean', default=True),
Field('is_military', 'boolean', default=True),
Field('password', 'password',readable=False,label='Password'),
Field('registration_key', length=128,
writable=False, readable=False, default=''))
db.person.first_name.requires = [IS_NOT_EMPTY()]
db.person.last_name.requires = [IS_NOT_EMPTY()]
db.person.password.requires = [CRYPT()] # password will be stored
hashed
db.person.email.requires = [IS_EMAIL(), IS_NOT_IN_DB(db,
db.auth_user.email)]
#t.death_date.requires=IS_NULL_OR(IS_DATE()
#t.web_page.requires=IS_URL()
#auth.define_tables() ### auth_user will not be redefined!
db.define_table('states',
Field('state_name',length=128),
Field('abbreviation',length=2))
db.define_table('category',
Field('category_name',length=128),
Field('abbreviation',length=5))
db.define_table('education',
Field('person',db.person),
Field('school_name',length = 50),
Field('start_date','date',default=now),
# Field('end_date','date',default=date(YYYY,MM,DD) ),
Field('end_date', 'date', label='Date of death',
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('address',length=128),
Field('city',length=128),
Field('states',db.states),
Field('country',length=128))
db.education.person.requires=IS_IN_DB
(db,'person.id','person.last_name')
db.education.states.requires=IS_IN_DB
(db,'states.id','states.state_name')
db.define_table('work',
Field('person',db.person),
Field('supervisor',db.person),
Field('start_date','date',default=now),
Field('end_date','date'),
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('amount','integer'),
Field('address',length=128),
Field('city',length=128),
Field('states',db.states),
Field('country',length=128))
db.work.person.requires=IS_IN_DB(db,'person.id','person.last_name')
db.work.states.requires=IS_IN_DB
(db,'states.id','states.state_name')
db.define_table('housing',
Field('person',db.person),
Field('start_date','date',default=now),
Field('end_date','date'),
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('address',length=128),
Field('city',length=128),
Field('states',db.states),
Field('country',length=128),
Field('amount','integer'))
db.housing.person.requires=IS_IN_DB(db,'person.id','person.last_name')
db.housing.states.requires=IS_IN_DB
(db,'states.id','states.state_name')
db.define_table('associations',
Field('person',db.person),
Field('contact',db.person),
Field('start_date','date',default=now),
Field('end_date','date'),
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('address',length=128),
Field('city',length=128),
Field('states',db.states),
Field('country',length=128),
Field('amount','integer'))
db.associations.person.requires=IS_IN_DB
(db,'person.id','person.last_name')
db.associations.states.requires=IS_IN_DB
(db,'states.id','states.state_name')
db.define_table('events',
Field('person',db.person),
Field('description',length=128),
Field('category',db.category),
Field('contact',db.person),
Field('start_date','date',default=now),
Field('end_date','date'),
required=False, default='', requires=IS_NULL_OR(IS_DATE(),
comment='optional ex: 1975-09-20'),
Field('address',length=128),
Field('city',length=128),
Field('states',db.states),
Field('country',length=128),
Field('zipcode',length=9),
Field('amount','integer'))
db.events.person.requires=IS_IN_DB(db,'person.id','person.last_name')
db.events.states.requires=IS_IN_DB(db,'states.id','states.state_name')
db.events.category.requires=IS_IN_DB
(db,'category.id','category.category_name')
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" 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
-~----------~----~----~----~------~----~------~--~---
