I am trying to do a combined update and insert using SQLFORM.factory with
some redirects for good measure.
Everything works fine except the update which fails to alter the record in
question.
@auth.requires_login()
def remote_check():
j_id=request.args[0]
for row in db(db.job_requests.id==j_id).select(db.job_requests.
business_name, db.job_requests.cta, db.job_requests.spoke_to, db.
job_requests.job_result, db.job_requests.job_note):
bus = row.business_name
contact = row.spoke_to
cta = row.cta
jn = row.job_note
jr = row.job_result
for row in db(db.clients.id==row.business_name).select(db.clients.id
, db.clients.phone):
c_id=str(row.id)
phone=row.phone
address = get_client_address(c_id)
db.job_requests.id.readable=False
db.job_requests.business_name.default=c_id
db.job_requests.business_name.writable=False
db.job_requests.sr_number.writable=False
db.job_requests.sr_number.readable=False
db.job_requests.cta.default=cta
db.job_requests.cta.writable=False
db.job_requests.send_via.writable=False
db.job_requests.send_via.readable=False
db.job_requests.email_to.writable=False
db.job_requests.email_to.readable=False
db.job_requests.fax_to.writable=False
db.job_requests.fax_to.readable=False
db.job_requests.snd_other.writable=False
db.job_requests.snd_other.readable=False
db.job_requests.spoke_to.default=contact
db.job_requests.spoke_to.writable=False
db.job_requests.job_result.default=jr
db.job_requests.job_note.default=jn
db.job_requests.job_note.writable=False
db.tech_notes.business_name.default=c_id
db.tech_notes.business_name.writable=False
form=SQLFORM.factory(db.job_requests,db.tech_notes,table_name=
'remote_check')
if form.process().accepted:
session.flash = 'Job Updated'
db.tech_notes.insert(**db.tech_notes._filter_fields(form.vars))
redirect(URL('ops', 'tech_main_page'))
if form.vars.job_result=='Completed':
db.job_requests.update(**db.job_requests._filter_fields(form.
vars))
redirect(URL('ops', 'tech_main_page'))
else:
redirect(URL('ops', 'maintenance_customer_service_request'))
elif form.errors:
response.flash = 'Form has errors'
return dict(form=form,phone=phone,address=address,left_sidebar_enabled=
True,right_sidebar_enabled=True)
Any hints please?
--
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.
