for f in db.table.fields:
print f
or
rows = db(db.fruits.id > 0).select(db.fruits.ALL) # ALL means all fields
for r in rows:
print(r)
You can control which field you want with the previous example
myfields = [f for f in db.table.fields if
SOME_FILTERING_CHECK_OVER_THE_FIELD_YOU_WANT]
for r in rows:
for f in myfields:
print(r[f])
You can play around that you should be able to figure out how you can do
what you wanna do.
Richard
On Fri, Apr 27, 2018 at 10:08 AM, Maurice Waka <[email protected]>
wrote:
> Addendum
>
> I want a single list of the items (the data from all fields)
>
> regards
>
> On Fri, Apr 27, 2018 at 5:06 PM, Maurice Waka <[email protected]>
> wrote:
>
>> There are several fields in my db such as this:
>>
>> db.define_table('fruit', Field('id', 'reference auth_user'),
>> Field('apple','boolean',label=T('Apple')),
>> Field('apricot','boolean',label=T('Apricot')),
>> Field('cherry','boolean',label=T('Cherry')), Field('fig','boolean',
>> label=T('Fig')), Field('lychee','boolean', label=T('Lychee')),
>> Field('peach','boolean', label=T('Peach')), Field('pear','boolean',
>> label=T('Pear')), Field('plum','boolean', label=T('Plum')))
>> If i want to print items from a specific field i would do:
>>
>> rows = db(db.fruits)select()for row in rows:
>> return row.apple
>>
>>
>> Now I want to return all data from all fields. How Can i go about it.
>>
>> I have tried:
>>
>> return rows and I get a blank screen.
>>
>> return [rows] and I get [<rows>].
>>
>> Kind regards
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>> pic/web2py/-Hlx1yh-4MU/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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/d/optout.
>
--
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/d/optout.
