is there any way to access to the sum column ? in this way we would not need to rename that column....
On Sat, Jun 20, 2009 at 6:43 AM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > Changing colnames that have the form "table.field" is a NO NO. That is > what I was referring to. > colnames that refer to aggregates can be changed. I agree it is not a > good idea anyway. > > Massimo > > On Jun 19, 3:19 pm, DenesL <denes1...@yahoo.ca> wrote: > > On Jun 19, 8:27 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > > These are different problems. Even you could do "as", which you > > > technically an but it is complicated, would not rename the web2py > > > column. > > > > > You can rename the column without the "as". > > > > > rows=db(..).select(...) > > > > > rows.colnames is a list with the colnames. You can change any element > > > in this list as you please. Look what is in there first. > > > > I believe changing colnames is a no-no. > > > > Fromhttp://groups.google.com/group/web2py/msg/b42be1fa72b2c591 > > > > <CITE> > > Changing row.colnames changes the way to retrieve columns when you > > change colnames. Bad. > > > > I take back my suggestion about changing colnames to change the column > > names. DO NOT DO IT. There is a better and cleaner way: > > > > Instead of simply printing {{=rows}}, print {{=SQLTABLE > > (rows,headers=headers)}} instead where headers is a dictionary you > > define that looks like this: > > > > headers={'book.author':'Author'} > > > > the headers names in the dictionary will be renamed accordingly. > > </CITE> > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
