I want to rename The column names to be readable to users and then i
will generate the csv report by str(family_members) so i cant use
SQLTable.
And by using
db.member.name.label = name
db.member.member_id = member ID
the columns are displayed with their names e.g: member.name and
member.membership_id
so please do you have any suggestions
Thanks
On Jan 5, 4:38 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> Please do not override family_members.colnames. This was an internal
> thing and its behavior changed in 1.72.*
> Use db.table.field.label instead or SQLTABLE(rows,headers={})
> depending on what you need.
>
> On Jan 5, 4:12 am, Neveen Adel <nevo.a...@gmail.com> wrote:
>
> > when i do the following code:
>
> > family_members =db(db.member.id == membership_id).select
> > (db.member.name,db.member.id)
> > family_members.colnames = ('Name ','Membership ID')
>
> > It cause the following error
> > ""
> > Traceback (most recent call last):
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > restricted.py", line 184, in restricted
> > File "/home/abeer/Desktop/resources/web2py/New_version/web2py_src/
> > web2py/applications/init/views/default/updateMember.html", line 142,
> > in <module>
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > globals.py", line 112, in write
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > html.py", line 103, in xmlescape
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > sql.py", line 3326, in xml
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > sqlhtml.py", line 980, in __init__
> > File "/home/abeer/Desktop/web2py/New_version/web2py_src/web2py/gluon/
> > sql.py", line 621, in __getattr__
> > KeyError: '_extra'
>
> > ""
> > P.s. : when i commented the lone (family_members.colnames = ('Name
> > ','Membership ID')) it works fine i dont why??
>
> > Thanks
>
>
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@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.
