send me a patch.
On Dec 6, 6:29 pm, Bruno Rocha <rochacbr...@gmail.com> wrote: > One more time: > > in sqlhtml.py we have: > > if headers=='fieldname:capitalize': headers = {} > for c in columns: headers[c] = ' '.join([w.capitalize() > for w in c.split('.')[-1].split('_')]) > > so what about including the peace of code I mentioned? > > if headers=='labels': > headers = {} > for c in columns: > tablename = ' '.join([w for w in c.split('.')[0].split('_')]) > fieldname = ' '.join([w for w in c.split('.')[-1].split('_')]) > headers[c] = sqlrows.db[tablename][fieldname].label > > 2010/12/6 Bruno Rocha <rochacbr...@gmail.com> > > > > > I do not want a form, a need to use the plugin_datatable. > > > Finally what I did: > > > # In models > > def get_header_labels(table=None): > > headers = {} > > for field in db[table].fields: > > headers[table+'.'+field] = db[table][field].label > > return headers > > > # in My view/controller > > > list = SQLTABLE(db(db.category.id>0). select(db.category.id, > > db.category.name), > > headers = get_header_labels('category')) > > > 2010/12/6 mdipierro <mdipie...@cs.depaul.edu> > > > if you make a form there is a dict in form.custom.label[fielname] or > >> form.custom.label.fielname > > >> On Dec 6, 5:19 pm, Bruno Rocha <rochacbr...@gmail.com> wrote: > >> > OK, I found that labels are in db.fieldname.label, now I just have to > >> create > >> > a dict. > > >> > 2010/12/6 Bruno Rocha <rochacbr...@gmail.com> > > >> > > HI, > > >> > > I have a 'category' table: > > >> > > db.define_table('category', > >> > > Field('name',label=T('Name')), > >> > > signature, > >> > > format='%(name)s' > >> > > ) > > >> > > which I defined a label for the field 'name' > > >> > > I need to create something like: > > >> > > list = plugin_datatable(db(db.category.id>0).select(db.category.id, > >> > > db.category.name), > >> > > _class='datatable', > >> > > headers = {'category.name':T('Name')}, > >> > > ) > > >> > > Is there a way to pass my previously defined labels to the SQLTABLE? > > >> > > where the 'labels' are stored? I tried db.category.labels, > >> > > db.category['labels'] ? > > >> > > Thanks > > >> > > -- > > >> > > Bruno Rocha > >> > >http://about.me/rochacbruno/bio > > >> > -- > > >> > Bruno Rochahttp://about.me/rochacbruno/bio > > > -- > > > Bruno Rocha > >http://about.me/rochacbruno/bio > > -- > > Bruno Rochahttp://about.me/rochacbruno/bio