start with:
def cost3():
jnum = request.args(0,cast=int)
a = 0
results = db(db.PO.job_id==jnum).select()
for row in results:
a = a + row.mycost
return dict(a=a, howmany=len(results))
so you can check how many rows are you actually selecting :P
On Sunday, January 4, 2015 4:17:03 AM UTC+1, Greg White wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
