Hey guys,
Excuse me if I'm missing something (or a lot), but I'm pretty experienced
with web2py.
I have the following defined in my model:
db.define_table('bursary_users',
> Field('forename', type='string', requires=IS_NOT_EMPTY()),
> Field('surname', type='string', requires=IS_NOT_EMPTY()),
> Field('studentId', type='string', requires=IS_NOT_EMPTY(),
> unique=True),
> Field('barcode', type='string', requires=IS_NOT_EMPTY(),
> unique=True),
> Field('email', type='string', requires=IS_EMAIL(),
> unique=True),
> Field('bursary', requires=IS_IN_SET(['Free school
> meals','Bursary','Disabled'])),
> Field('notes', type='text'),
> format='%(studentId)s'
> )
> db.define_table('bursary_entries',
> Field('barcode', 'reference bursary_users', requires =
> [IS_IN_DB(db, 'bursary_users.barcode')]),
> Field('entry_date', type='datetime', default=request.now,
> readable=False, writable=False),
> format='%(barcode)s'
> )
When I use the SQLFORM on a page, I can enter a barcode and it validates it
(Fails if not in bursary_users, pass if it is). However, when I come to
check the database, I'm getting a '0' (Althought it is hyperlinked to
nothing) for the barcode value and a correct value for the entry_date.
Any ideas why this is happening?
Kind regards,
James.
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
