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 -~----------~----~----~----~------~----~------~--~---
