I swapped that code in and like I suspected it isn't iterating through any row selections the results were 0 and 0. Could it have anything to do with the fact that the field referenced references another table and field?
db.define_table('PO', Field('job_id', db.jobinfo ), still stumped but thanks for the response On Monday, January 5, 2015 at 1:15:38 PM UTC-7, Niphlod wrote: > > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.