[web2py] Re: fields strings to variable for fields=fields

2015-03-28 Thread Gray Kanarek
With the information here http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Run-time-field-and-table-modification you can do db['mytable']['field1']. So you'd want something like: field_list_split = [i.split(.) for i in field_list] fields = [db[table][field] for d

[web2py] Re: fields strings to variable for fields=fields

2015-03-28 Thread Anthony
On Friday, March 27, 2015 at 3:39:38 PM UTC-4, LoveWeb2py wrote: > > Hi JorgeH, > > I didn't want to use eval due to code injection, but here is what I ended > up using and it worked. > > field_list = ['db.mytable.field1', 'db.mytable.field2'] > > fields = [getattr(db.mytable, i.split(".")[-1] fo

[web2py] Re: fields strings to variable for fields=fields

2015-03-27 Thread LoveWeb2py
Hi JorgeH, I didn't want to use eval due to code injection, but here is what I ended up using and it worked. field_list = ['db.mytable.field1', 'db.mytable.field2'] fields = [getattr(db.mytable, i.split(".")[-1] for i in field_list] and in SQLFORM fields=fields Thanks everyone!1 On Friday

[web2py] Re: fields strings to variable for fields=fields

2015-03-27 Thread JorgeH
have you tried eval ?? fields = [eval ('db.mytable.field1') , eval ('db.mytable.field2') ] (just a suggestion. I didn't tried myself) On Friday, March 27, 2015 at 2:24:06 PM UTC-5, LoveWeb2py wrote: > > having trouble with the SQLFORM.smartgrid fields section > > Fields only takes > > fie