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 [email protected].
For more options, visit https://groups.google.com/d/optout.
