Glad I could help.
On another note, Massimo just updated trunk to resolve the other issues
I was having with SQLFORM.smartgrid.
-Jim
On 11/11/2011 1:02 PM, JaapP wrote:
Thanks a lot, works perfect!
And now i even can set the order in which the columns are displayed;
this did not work with 'columns'
Bye,
Jaap
On 11 nov, 19:43, Jim Steil<j...@qlf.com> wrote:
This was due to a non-backward-compatible change that Massimo
implemented a day or so ago. You should be able to substitute your
usage of columns with fields. However, the syntax is a bit different.
Here is an example.
Using columns - no longer supported
columns = ['table.field1', 'table.field2']
Using fields -
fields = [db.table.field1, db.table.field2]
grid = SQLFORM.grid(query, fields=fields)
I'm still having some issues when using fields in SQLFORM.smartgrid, but
I think it should work fine in SQLFORM.grid.
-Jim
On 11/11/2011 12:22 PM, JaapP wrote:
Hi ,
could anyone give me an hint on this one please:
i've been playing with sqlform.grid and noticed that in web2py Version
1.99.3 (2011-11-11 10:27:54) dev i cannot use the columns option any
more (TypeError: grid() got an unexpected keyword argument 'colums')
This did work in previous version of web2py.
Should i use an other option to select the columns i want to display
or just revert back to older version of web2py?
Thanks in advance for any help!
Jaap
