Is there a way to expand the amount of characters in a field? I've noticed that SQLTABLE (or more specifically, gluon.html.TABLE) tends to truncate the amount of visible text. I'm attempting to us the plugin_datatable plugin to display data, but I can't seem to show the full contents of the record.
Thanks! On Jan 23, 6:36 pm, mdipierro <[email protected]> wrote: > rows = db(query).select(db.sarua.ALL,limitby = (0,25)) > records =SQLTABLE(rows, headers=dict([('sarua.'+f,db.sarua > [f].label) > for f in db.sarua.fields])) > dict(records=records) > > On Jan 23, 4:55 pm, Johann Spies <[email protected]> wrote: > > > > > On 21 January 2010 16:08, mdipierro <[email protected]> wrote: > > > > massimo-di-pierros-macbook:web2py_jeeva mdipierro$ python web2py.py -S > > > welcome > > > ... > > >>>> help(SQLTABLE) > > > classSQLTABLE(gluon.html.TABLE) > > > | given a SQLRows object, as returned by a db().select(), generates > > > | an html table with the rows. > > > | > > > | optional arguments: > > > | > > > | :param linkto: URL (or lambda to generate a URL) to edit > > > individual records > > > | :param upload: URL to download uploaded files > > > | :param orderby: Add an orderby link to column headers. > > > | :param headers: dictionary of headers to headers redefinions > > > > example > > > >SQLTABLE(rows,headers = {'table.field':'Label Field', ....}) > > > I am sorry to bother you, but I do not understand it properly. > > > In my controller now I have: > > > r =SQLTABLE(db(query).select(db.sarua.ALL,limitby = (0,25))) > > records = r(rows, headers=dict([('sarua.'+f,db.sarua[f].label) > > for f in db.sarua.fields])) > > dict(records=records) > > > And get the error: > > > NameError: global name 'rows' is not defined > > > So where and how do I do this? > > > Johann -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
