I have 2 tables one table references the other table.
db.define_table('store_registration',
Field('first_name', requires=IS_NOT_EMPTY()),
Field('last_name', requires=IS_NOT_EMPTY()),
Field('contact_number', label=SPAN('Cell Number'), requires=
IS_NOT_EMPTY()),
Field('id_number', requires=IS_NOT_EMPTY()),
Field('program', requires=IS_NOT_EMPTY()),
Field('level_is', label=SPAN('Level'), requires=IS_NOT_EMPTY
()),
Field('module_is', label=SPAN('Module'), requires=
IS_NOT_EMPTY()),
Field('branch', label=SPAN('Branch'), requires=IS_NOT_EMPTY
()),
Field('residential_place', label=SPAN('Residence'), requires
=IS_NOT_EMPTY()),
Field('region', 'reference auth_group', default=get_group(),
writable=False), #*Here*
Field('recorded_by', 'reference auth_user', default=auth.
user_id, writable=False),
format="%(first_name)s %(last_name)s"
)
db.define_table('temperatures',
Field('employee', 'reference store_registration', writable=
False),
Field('branch', 'reference store_registration', writable=
False),
Field('temperature', requires=IS_NOT_EMPTY()),
Field('ID_No', 'reference store_registration', writable=
False),
Field('Cell_No', 'reference store_registration', writable=
False),
Field('residential', 'reference store_registration',
writable=False))
I am trying to have the referenced fields pre-populated with their default
values in a table form so that I don't have to populate them manually like
this:
def client_details():
details=db.store_registration(request.args(0, cast=int))
db.temperatures.employee.default=details.id
db.temperatures.ID_No.default=details.id_number
db.temperatures.Cell_No.default=details.contact_number
db.temperatures.branch.default=details.branch
db.temperatures.residential.default=details.residential_place
form=SQLFORM(db.temperatures)
if form.process().accepted:
response.flash=T('Temp Recorded')
return locals()
But this gives me an error:
<type 'exceptions.ValueError'> invalid literal for long() with base 10:
I read somewhere that this occurs because
*reference fields are intended to store the integer record ID's of the
referenced records, not copies of string fields from referenced records**.*
Is there a way I can achieve my above task without causing this error?!
Regards;
Mostwanted
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/9d29a0a4-aa4e-421a-b04a-698c5c055840o%40googlegroups.com.
