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: > > then do a > > def cost3(): > jnum = request.args(0,cast=int) > a = 0 > thequery = db(db.PO.job_id==jnum)._select() > results = db(db.PO.job_id==jnum).select() > for row in results: > a = a + row.mycost > return dict(a=a, howmany=len(results), thequery=thequery) > > too see if the underlying t-sql is correct. > -- 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.