I am brand new to web2py and know a little python, so I am a definite
novice. I am trying to build a purchasing agent app and am getting result
"0" from function cost3. I am expecting to get a sum of the values for a
specified job number (in cost2) in table PO Field mycost when I specify a
job number in function cost2.. but I am not getting a sum of those numbers
but am getting 0 instead. Any help would be appreciated, thanks.
db
db.define_table('jobinfo',
Field('jobnumber', 'integer', requires=IS_NOT_EMPTY()),
Field('jobname', 'string', requires=IS_NOT_EMPTY()),
Field('jobbudget', 'double'),
format = '%(jobnumber)s')
db.define_table('vendortype',
Field('vtype', 'string', requires=IS_NOT_EMPTY()),
format = '%(vtype)s')
db.define_table('vendorr',
Field('company_name',requires=IS_NOT_EMPTY()),
Field('address1',requires=IS_NOT_EMPTY()),
Field('address2'),
Field('city',requires=IS_NOT_EMPTY()),
Field('co_state',requires=IS_NOT_EMPTY()),
Field('zip',requires=IS_NOT_EMPTY()),
Field('vendor_type', db.vendortype),
Field('terms'),
format = '%(company_name)s')
db.define_table('POreq',
Field('job_id', db.jobinfo, requires=IS_NOT_EMPTY()),
Field('Vendor_id', db.vendorr, requires=IS_NOT_EMPTY()),
Field('Qty_1'),
Field('Description_1'),
Field('Notes_1'),
Field('RequiredBy_1','date'),
format = '%(Vendor_id)s')
db.define_table('PO',
Field('job_id', db.jobinfo ),
Field('vname',db.vendorr),
Field('Qty_1', 'double'),
Field('Description_1'),
Field('Notes_1'),
Field('RequiredBy_1','date'),
Field('mycost', 'double'),
format = '%(job_id)s')
controller
def cost2():
form=FORM('Job Number: ',
INPUT(_name='jobnumber', requires=IS_INT_IN_RANGE(0,9000)),
INPUT(_type='submit')).process()
if form.accepted:
redirect(URL('cost3',args=form.vars.jobnumber))
return dict(form=form)
def cost3():
jnum = request.args(0,cast=int)
a = 0
for row in db(db.PO.job_id==jnum).select():
a = a + row.mycost
return a
--
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/d/optout.
