Hi there,
I am building an app to store electrical consumption data . I
have build a database which include three tabled dept,meter and reading.
THe problem that i have encountered is with the syntax in the following
code:
def reg_meter():
form = SQLFORM.factory(
Field('meter_num',requires=IS_IN_DB(db,db.meter)),
Field('meter_type',requires=IS_IN_DB(db,db.meter)),
Field('dept_id',requires=IS_IN_DB(db,db.dept.id,'%(dept_id)s')).process()
if form.accepted:
entered = db((db.entered.meter_num == form.vars.meter_num) &
(db.entered.meter_type == form.vars.meter_type) & (db.entered.dept_id ==
form.vars.dept_id)).select().first()
if entered:
entered.update_record((meter_num =
entered.meter_num+form.vars.meter_num) & (meter_type =
entered.meter_type+form.vars.meter_type) & (dept_id =
entered.dept_id+form.vars.dept_id)
else:
db.entered.insert(meter_num=form.vars.meter_num,meter_type=form.vars.meter_type,
dept_id=form.vars.dept_id)
response.flash = 'new record inserted'
elif form.errors:
response.flash = 'invalid values in form'
records =
SQLTABLE(db().select(db.meter.ALL),headers='fieldname:capitalize')
return dict(form=form, records=records)
It is a function in the default.py for inserting the values. The error is a
syntax error which im not able to debug. Kindly guide me thru the issue.
the syntax error is at the line ' if form.accepted:' May be the error is
at some other line which i cant find out.
Thanks !
kartik
--
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/groups/opt_out.
