assuming the fields exist:
fields=[db.monthly_projections.employee, db.monthly_projections.id, db.
monthly_projections.costcode]
for row in db(db.months).select():
fields.append(db.monthly_projections[row.effort_month.strftime('%b_%Y')])
or
fields=[db.monthly_projections.employee, db.monthly_projections.id, db.
monthly_projections.costcode] + \
[db.monthly_projections[row.effort_month.strftime('%b_%Y')] for row in db
(db.months).select()]
On Sunday, 8 December 2013 23:40:10 UTC-6, P T wrote:
>
> I am dynamically creating the fields in a table from entries in another
> table. I am using SQLFORM.grid to view/edit the table.
>
> For the grid, the following field list works fine:
> fields=[db.monthly_projections.employee, db.monthly_projections.id, db.
> monthly_projections.costcode,
> db.monthly_projections.Dec_2013, db.monthly_projections.
> Jan_2014, db.monthly_projections.Feb_2014]
>
> But, the problem is I don't know the complete field list ahead of time.
> So, I am using this instead:
> fields=[db.monthly_projections.employee, db.monthly_projections.id, db.
> monthly_projections.costcode]
> for row in db(db.months).select():
> fields.append('db.monthly_projections.'+ row.effort_month.strftime(
> '%b_%Y'))
>
> This is giving an error
> <type 'exceptions.AttributeError'> 'str' object has no attribute
> 'tablename'
>
> On debugging, I see that the fields is created as three gluon.dal.Fields
> and three strings
>
> fields
> [<gluon.dal.Field object at 0x0000000005414470>,
> <gluon.dal.Field object at 0x00000000046D7A58>,
> <gluon.dal.Field object at 0x0000000009F15D30>,
> 'db.monthly_projections.Dec_2013',
> 'db.monthly_projections.Jan_2014',
> 'db.monthly_projections.Feb_2014']
>
> So, I changed the definition of fields to:
> fields=[db.monthly_projections.employee, db.monthly_projections.id, db.
> monthly_projections.costcode]
> for row in db(db.months).select():
> fields.append(Field('db.monthly_projections.'+ row.effort_month.
> strftime('%b_%Y')))
>
> and this gives an error:
> <type 'exceptions.SyntaxError'> invalid table or field name:
> db.monthly_projections.Dec_2013
> So, in short, how do I build the field list from string for SQLFORM.grid?
>
> Thanks for your help!
> PT
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
