This works. I need some guidance as to where to look because I am going to be dealing with more calculations that includes multiplications.
Thanks dan On May 11, 2:34 pm, mdipierro <[email protected]> wrote: > I personally do not. The university I work for (DePaul Universty) > offers this certificate > program:http://www.cdm.depaul.edu/ipd/Programs/Pages/WebDevelopmentwithPython... > (as long as other programs on Java and Rails and more). > > I teach it. I may teach it in Fall but I am not sure yet. > > Massimo > > On May 11, 1:24 pm, greenpoise <[email protected]> wrote: > > > will try. Thanks. > > > ** Dont know if this is the appropriate place to ask for this but > > looking around the group I saw a post about a class certificate > > offering. Do you have an online class by any chance? > > > On May 11, 2:16 pm, mdipierro <[email protected]> wrote: > > > > First I would rewrite it as > > > > def view_totals(): > > > rows = db().select(db.tableorder.ALL, > > > db.tableorder.totalsale.sum(),groupby=db.tableorder.orderdate) > > > for row in rows: print > > > row.tableorder.ordernumber,row[db.tableorder.totalsale.sum()] > > > return dict(rows=rows) > > > > <table> > > > {{for row in rows:}} > > > <tr><td>{{= row.tableorder.ordernumber}}</ > > > td><td>{{=row[db.tableorder.totalsale.sum()]}}</td></tr> > > > {{pass}} > > > </table> > > > > On May 11, 12:37 pm, greenpoise <[email protected]> wrote: > > > > > I have this: > > > > > def view_totals(): > > > > rows = db().select(db.tableorder.ALL, 'sum(tableorder.totalsale)', > > > > groupby=db.tableorder.orderdate) > > > > for row in rows: print row.tableorder.ordernumber, > > > > row._extra['sum(tableorder.totalsale)'] > > > > return dict() > > > > > What would be my view to present my sum?
