Ok! It works, thanks Alex
I will have much more work since fields=['field1','field etc.'] broke the behavior of the headers dict... So I can't hide field I don't want to show... I probably must specify a query that will only include the column I want... Richard On Fri, Oct 15, 2010 at 7:29 PM, Alex <yue.a...@gmail.com> wrote: > Here you go, I just tested this: > > selected=crud.select(table, headers={'table.field1': > 'capitalize'}) > > You have to explicitly specify the table name of the field you want to > label. > > > On Oct 15, 4:54 pm, Richard Vézina <ml.richard.vez...@gmail.com> > wrote: > > I try in many ways with no success... > > > > I read somewhere that headers='fieldName:capitalize' was the only > parameter > > for headers accepted... > > > > What I did : > > > > > selected=crud.select(table,field_labels={'field1':'abc'},headers='fieldname:capitalize') > > > > selected=crud.select(table,field_labels={'field1':'abc'}) > > > > > selected=crud.select(table,fields=['field1'],field_labels={'field1':'abc'},headers='fieldname:capitalize') > > > > > selected=crud.select(table,field_labels={'result':'Edit'},headers='fieldname:capitalize') > > > > > selected=crud.select(table,fields=['field1'],field_labels={'field1':'abc'},headers='fieldname:capitalize') > > > selected=crud.select(table,fields=['field1'],field_labels={'field1':'abc'}) > > selected=crud.select(table,fields=['field1'],labels={'field1':'abc'}) > > > > Nothing! > > > > Thanks anyway. > > > > Richard > > > > > > > > On Fri, Oct 15, 2010 at 3:23 PM, Alex <yue.a...@gmail.com> wrote: > > > Maybe it's the syntax? > > > > > headers={'person.name': 'Name', 'table.colName': 'MyNewName'} > > > > > Not: headers='fieldName:capitalize'.... > > > > > On Oct 15, 8:00 am, Richard Vézina <ml.richard.vez...@gmail.com> > > > wrote: > > > > Hello, > > > > > > It's not working... I am really confuse... I try with 1.83.2 and > 1.87.3. > > > > > > I try with fields=['myfield1','myfield2'] and without it always > > > > with field_labels and also with and > > > > without headers='fieldname:capitalize'... > > > > > > Is it a issue? > > > > > > Richard > > > > > > On Thu, Oct 14, 2010 at 8:16 PM, Alex <yue.a...@gmail.com> wrote: > > > > > Are you trying to display a more user friendly column name rather > than > > > > > the DB column name? > > > > > > > If so, you can do this already. The crud.select() has a method > called > > > > > "field_labels", which takes a dictionary of field names to their > > > > > labels. > > > > > > >http://www.web2py.com/book/default/chapter/07#Methods > > > > > > > crud.select(db.person, field_labels={'dbColName':'MyLabel'}) > > > > > > > On Oct 14, 3:00 pm, Richard Vézina <ml.richard.vez...@gmail.com> > > > > > wrote: > > > > > > Hello, > > > > > > > > Does it plan to have the possibility to specify the labels of > fields > > > in a > > > > > > crud.select?? > > > > > > > > Richard- Hide quoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text -