Hi Bruno,
I tried both of these but neither one worked. I just wound up with an
empty table. I wasn't sure why you used Row objects in one list
comprehension and Storage objects in the other, but neither one
produced a list that the table likes. :( Not sure what's going on
there but there were no exceptions thrown and I know the raw rows list
is properly populated prior to the conversion to Rows.
Thanks,
David
On Nov 16, 8:09 pm, Bruno Rocha <rochacbr...@gmail.com> wrote:
> wait, there is a better way.
>
> >>> from gluon.dal import Rows, Row
> >>> result = access.db.executesql("SELECT first_name, last_name FROM
>
> auth_user", as_dict=True)>>> rows = Rows(records=[Row(item) for item in
> result])
> >>> rows[0].first_name
>
> u'Bruno'
>
> You can set other values for each Row.
