Hi Annet,
the error is in the first line
Field('inschrijving',length='36',...
should be
Field('inschrijving',length=36,...
Denes
On Oct 19, 8:07 am, annet <[email protected]> wrote:
> I defined the following table:
>
> db.define_table('applicationform',
>
> Field('inschrijving',length='36',default='',notnull=True,ondelete='RESTRICT'),
> Field('bedrijfsnaam',length=54,default='',notnull=True),
> Field('kvk_nummer',length=8),
> Field('subdossiernummer',length=4,default='0000'),
> Field('rechtsvorm',default='',notnull=True),
> Field('straat',length=42,default='',notnull=True),
> Field('huisnummer',length=9,default='',notnull=True),
> Field('huisnummerextensie',length=6),
> Field('postcode',length=7,default='',notnull=True),
> Field('plaats',length=42,default='',notnull=True),
> Field('telefoonnummer',length=72),
> Field('faxnummer',length=72),
> Field('mobielnummer',length=72),
> Field('email',length=72),
> Field('website',length=72),
> Field('aanhef'),
> Field('first_name',length=24),
> Field('last_name',length=42,default='',notnull=True),
> Field('email_persoon',length=72,default='',notnull=True),
> Field('application',length=24,writable=False,readable=False),
> Field('created_on',type='datetime',writable=False,readable=False),
>
> Field('modified_on',type='datetime',writable=False,readable=False),
> Field('replied_on',type='datetime',writable=False,readable=False),
> migrate=False)
>
> db.applicationform.inschrijving.requires=IS_IN_DB(db,db.inschrijving.inschrijving,'%
> (inschrijving)s',zero=None)
> db.applicationform.bedrijfsnaam.requires=[IS_LENGTH(54,error_message='lengte
> overschreidt 54 tekens'),IS_NOT_EMPTY()]
> db.applicationform.bedrijfsnaam.label='Bedrijfsnaam * '
> db.applicationform.kvk_nummer.requires=[IS_MATCH('\d{8}',error_message='geen
> match 8 cijfers'),IS_NOT_EMPTY()]
> db.applicationform.kvk_nummer.label='Kvk-nummer * '
> db.applicationform.subdossiernummer.requires=[IS_MATCH('\d{4}',error_message='geen
> match 4 cijfers'),IS_NOT_EMPTY()]
> db.applicationform.subdossiernummer.default='0000'
> db.applicationform.subdossiernummer.label='Subdossiernummer * '
> db.applicationform.rechtsvorm.requires=IS_IN_DB(db,db.rechtsvorm.rechtsvorm,'%
> (rechtsvorm)s',zero=None)
> db.applicationform.rechtsvorm.default='Onbekend'
> db.applicationform.straat.requires=[IS_LENGTH(42,error_message='lengte
> overschreidt 42 tekens'),IS_NOT_EMPTY()]
> db.applicationform.straat.label='Straat * '
> db.applicationform.huisnummer.requires=[IS_LENGTH(9,error_message='lengte
> overschreidt 9 tekens'),IS_NOT_EMPTY()]
> db.applicationform.huisnummer.label='Huisnummer * '
> db.applicationform.huisnummerextensie.requires=IS_LENGTH(6,error_message='length
> overschreidt 6 tekens')
> db.applicationform.postcode.requires=[IS_LENGTH(7,error_message='length
> overschreidt 7 tekens'),IS_NOT_EMPTY()]
> db.applicationform.plaats.requires=[IS_IN_DB(db,db.plaats.plaats,'%
> (plaats)s')]
> db.applicationform.plaats.widget=SQLFORM.widgets.autocomplete(request,db.plaats.plaats,min_length=2)
> db.applicationform.plaats.label='Plaats * '
> db.applicationform.telefoonnummer.requires=IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens')
> db.applicationform.faxnummer.requires=IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens')
> db.applicationform.mobielnummer.requires=IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens')
> db.applicationform.email.requires=[IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens'), IS_NULL_OR(IS_EMAIL())]
> db.applicationform.email.label='E-mail'
> db.applicationform.website.requires=IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens')
> db.applicationform.website.label='Web site'
> db.applicationform.aanhef.requires=IS_IN_SET(['de
> heer','mevrouw'],zero=None)
> db.applicationform.first_name.requires=IS_LENGTH(24,error_message='lengte
> overschreidt 24 tekens')
> db.applicationform.first_name.label='Voornaam'
> db.applicationform.last_name.requires=[IS_LENGTH(42,error_message='lengte
> overschreidt 42 tekens'),IS_NOT_EMPTY()]
> db.applicationform.last_name.label='Achternaam * '
> db.applicationform.email_persoon.requires=[IS_LENGTH(72,error_message='lengte
> overschreidt 72 tekens'), IS_EMAIL(), IS_NOT_EMPTY()]
> db.applicationform.email_persoon.label='E-mail * '
> db.applicationform.application.requires=IS_LENGTH(24,error_message='lengte
> overschreidt 24 tekens')
> db.applicationform.created_on.default=request.now
> db.applicationform.modified_on.default=request.now
> db.applicationform.modified_on.update=request.now
> db.applicationform.replied_on.default=''
>
> In this function I expose the form:
>
> def application_form():
> if not len(request.args):
> redirect(URL(r=request,c='default',f='error'))
> else:
> response.functionname='Aanmeldingsformulier'
> db.applicationform.application.default=request.args(0)
> form=SQLFORM(db.applicationform)
> form[0].insert(0,TR(H4('Bedrijfsgegevens:')))
> form[0].insert(5,TR(H4('Adresgegevens:')))
> form[0].insert(11,TR(H4('Communicatiegegevens:')))
> form[0].insert(17,TR(H4('Contactpersoon:')))
> form[0][-1][1].append(INPUT(_type='reset',_value='Reset'))
> if form.accepts(request.vars,session):
> response.flash='Het formulier is verzonden, u ontvangt
> binnen 5 werkdagen een reactie'
> mail.send(to=['[email protected]'],
> subject='Aanmeldingsformulier ' + form.vars.bedrijfsnaam, message='')
> form=[]
> elif form.errors:
> response.flash=response.flash_formerror
> else:
> if request.args(0)=='crm':
> response.flash='Uw bedrijfsgegevens in ons systeem
> zijn onvolledig, om die reden is het systeem niet in staat een
> wijzigingsformulier te genereren. Wij verzoeken u vriendelijk het
> aanmeldingformulier in te vullen, zodat wij uw bedrijfsgegevens in ons
> systeem kunnen invoeren.'
> else:
> response.flash=response.flash_form
> return dict(form=form)
>
> When the user submits the form I get the following errror:
>
> Error traceback
>
> Traceback (most recent call last):
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/
> restricted.py", line 188, in restricted
> exec ccode in environment
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/applications/
> util/controllers/form.py", line 82, in <module>
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/
> globals.py", line 96, in <lambda>
> self._caller = lambda f: f()
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/applications/
> util/controllers/form.py", line 47, in application_form
> if form.accepts(request.vars,session):
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/
> sqlhtml.py", line 1103, in accepts
> self.vars.id = self.table.insert(**fields)
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/sql.py",
> line 2029, in insert
> query = self._insert(**fields)
> File "/Library/Python/2.5/site-packages/web2py_1.87.3/gluon/sql.py",
> line 2009, in _insert
> value = value[:field.length]
> TypeError: slice indices must be integers or None or have an __index__
> method
> Error snapshot
> Detailed traceback description
> Exception: <type 'exceptions.TypeError'>(slice indices must be
> integers or None or have an __index__ method)
> Python 2.5.1: /System/Library/Frameworks/Python.framework/Versions/2.5/
> Resources/Python.app/Contents/MacOS/Python
> File /Library/Python/2.5/site-packages/web2py_1.87.3/gluon/
> restricted.py in restricted at line 188
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/applications/util/
> controllers/form.py in <module> at line 82
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/gluon/globals.py
> in <lambda> at line 96
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/applications/util/
> controllers/form.py in application_form at line 47
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/gluon/sqlhtml.py
> in accepts at line 1103
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/gluon/sql.py in
> insert at line 2029
> [ code | arguments | variables ]
> File /Library/Python/2.5/site-packages/web2py_1.87.3/gluon/sql.py in
> _insert at line 2009
> [ code | arguments | variables ]
> Function argument list: (self=<Table {'last_name': <gluon.sql.Field
> object at ...>, '_id': <gluon.sql.Field object at 0x602d570>}>,
> **fields={'aanhef': 'de heer', 'bedrijfsnaam': 'test', 'email': None,
> 'email_persoon': '[email protected]', 'faxnummer': '', 'first_name':
> '', 'huisnummer': '6', 'huisnummerextensie': '', 'inschrijving':
> 'Fitnesscentrum', 'kvk_nummer': '12345678', ...})
>
> fs.append(fieldname)
> value = fields[fieldname]
> if hasattr(value,'id'):
> value = value.id
> elif ft == 'string' and isinstance(value,
> (str,unicode)):
> value = value[:field.length]
>
> vs.append(sql_represent(value, ft, fd,
> self._db._db_codec))
> elif field.default != None:
> fs.append(fieldname)
> vs.append(sql_represent(field.default, ft, fd,
> self._db._db_codec))
> field: <gluon.sql.Field object at 0x6015ef0>
> field.length: '36'
> value: 'Fitnesscentrum'
>
> I defined similar tables and functions which all work, I have no idea
> why this function returns an error, I hope one of you does.
>
> Kind regards,
>
> Annet.
