ok, hey, this is my recreation of the auth_user define table so that the register form will show the fields in the correct order:
db.define_table('auth_user',
#Field('username', length=128, default='', unique=True),
Field('email', length=128, default='', unique=True, comment="used for login. all lowercase.",),
Field('prefix_title', length=4, requires=IS_IN_SET(('Mr.','Ms.','Mrs.','Dr.')), label="Prefix", comment='Enter your Name Prefix.',),
Field('first_name', length=128, default='',),
Field('last_name', length=128, default='',),
Field('gender', length=6, default='FEMALE', requires=IS_IN_SET(('FEMALE','MALE',)), comment='Enter your Gender.',),
Field('zip', length=12, requires=IS_NOT_EMPTY(), label="Zip Code", comment='Your Zip or Postal Code.',),
#Field('birthdate', 'date', requires=NE, comment='Enter in Format: "YYYY-MM-DD"',),
Field('password', length=256, default='',),
Field('input_date', 'date', requires=IS_NOT_EMPTY(), default=date.today(), writable=False, readable=False, comment="format YYYY-MM-DD",),
Field('sso_id', length=256, default='', writable=False, readable=False,), # For internal use by Auth
Field('action_token', length=256, default='', writable=False, readable=False,), # For internal use by Auth
Field('last_password_change', 'datetime', default=None, writable=False, readable=False,), # For internal use by Auth
Field('past_passwords_hash', 'list:string', writable=False, readable=False,), # For internal use by Auth
format = '%(email)s')
and the form looks good except the password does not have the retype_confirmation field. how do I add that to the form? really, how do I access the form to append that field?