[web2py] Re: Check to see if a field is in another table in a computed field

day, February 11, 2016 at 6:02:16 PM UTC-5, Greg White wrote: >> >> I should have mentioned that I tried IS_IN_DB first off and it didn't work >> >> On Wednesday, February 10, 2016 at 4:25:48 PM UTC-7, Dave S wrote: >>> >>> >>> >>> On Wed

[web2py] Re: Check to see if a field is in another table in a computed field

I should have mentioned that I tried IS_IN_DB first off and it didn't work On Wednesday, February 10, 2016 at 4:25:48 PM UTC-7, Dave S wrote: > > > > On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, Greg White wrote: >> >> Want a computed field to show whether or

[web2py] Check to see if a field is in another table in a computed field

Want a computed field to show whether or not a field value exists in another table started with this... db.define_table( 'inventory', Field('name'), Field('qty', label='Quantity'), Field('MatSize',label='Material Size'), format = '%(name)s') db.define_table(

[web2py] Re: Not getting expected results from a query

Thanks for the help, got it working. I need to learn some debugging techniques for web2py, but you have pointed me in the right direction for this kind of problem, if anyone has any suggested links it would be appreciated, thanks! On Friday, January 9, 2015 at 1:15:13 AM UTC-7, Niphlod wrote:

[web2py] Re: Not getting expected results from a query

=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

[web2py] Not getting expected results from a query

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