It looks like you are missing the closing ')' on the entered.update_record
line.
If that doesn't fix it please include the error message that you are
getting.
On Thursday, January 9, 2014 6:00:52 AM UTC-5, Federico Ferraro wrote:
>
> form.process().accepted:
> El ene 9, 2014 7:00 a.m., "kartik murthy" <619.k...@gmail.com<javascript:>>
> escribió:
>
>> 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 web2py+un...@googlegroups.com <javascript:>.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
