DAL return all Fields

Maurice Waka

unread,

Apr 27, 2018, 10:06:04 AM4/27/18

to web2py-users

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

Maurice Waka

unread,

Apr 27, 2018, 10:10:03 AM4/27/18

to web...@googlegroups.com

Addendum

I want a single list of the items (the data from all fields)

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/topic/web2py/-Hlx1yh-4MU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Richard Vézina

unread,

Apr 27, 2018, 11:16:33 AM4/27/18

to web2py-users

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

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 web2py+unsubscribe@googlegroups.com.

Maurice Waka

unread,

Apr 28, 2018, 11:02:55 AM4/28/18

to web...@googlegroups.com

Thanks, but I seem to be having a challenge when returning the rows from a specific id name or number. I tried this on a different app as follows:

Model:

db.define_table( "health",

Field('name', 'string'),

Field('definition', 'text', length= 1000000, default="We'll update soon.", notnull=True),

Field('abnvals', 'text', length= 1000000,default="We'll update soon.", notnull=True),

Field('normvals', 'text', length= 1000000,default="We'll update soon.", notnull=True),

def selections():

code

return name4# name4 is a list that contains items found in db.health.name, as well as other dbs.

def refer11():

db = current.db

rows = db(db.health).iterselect()

for row in rows:

id = row.name

if id == item in name4:

#return [', '.join(item) for item in rows]# Gives a list of the titles only as: ['name','definition','abnvals','normvals',]

#return [item for item in rows]# Gives this: [<row>

#return row# gives this : <row>

#return [item for item in row]# Gives a list of the titles only as: ['name','definition','abnvals','normvals',]

When using sql speak, this works well:

def refer11():

id = 0

location = ""

conn = sqlite3.connect('wellness.db')

c = conn.cursor()

c.execute('select * from health')

records = c.fetchall()

for record in records:

id = record[1]

for item in name4:

if id == item in name4:

return record[2:]

If row.name has e.g. apple, mango, guava, pineapple, then

and the fields contain info about the fruits e.g.

if id/row.name picks mango, i want a list of these:

definition data: A mango is a fruit blah blah blah.

abnvals data: A mango when its green is bitter to taste.

normvals data: A mango when ripe looks bright yellow and tastes sweet.

so when doing return row

I should get ['A mango is a fruit blah blah blah. A mango when its green is bitter to taste. A mango when ripe looks bright yellow and tastes sweet.]

and not

['name','definition','abnvals','normvals',]

Richard Vézina

unread,

Apr 30, 2018, 1:09:02 PM4/30/18

to web2py-users

Man this is convulated...

Not sure what is in name4 "name4 is a list that contains items found in db.health.name, as well as other dbs." what items are you referring at?? What other dbs?

Why are you connecting to sqlite by your own...

This check is just weird :

if id == item in name4:

I would suggest you don't use function to achieve what you try to do it just make it overcomplicated... Also never define functions in models files it will slow down your app as models files are executed at each request.

My guess is that if you end with the final list that you showed us is because at some point you put the name of the fields you want instead of the value attached to them...

But seriously it very difficult to help...

You could show us all the models that are important to the problem and show us an example of what you want at the end.

I also don't know from you field name in health table what they content.

So for example let say

You have a table name fruit

rows = db(db.fruit.id > 0).select(db.fruit.ALL)

With a fruit_name field

for r in rows:

print('A {0} is a fruit blah blah blah. A {0} when its green is bitter to taste. A {0} when ripe looks bright yellow and tastes sweet.'.format(r.fruit_name)

That's it!!

Richard

Maurice Waka

unread,

Apr 30, 2018, 1:22:03 PM4/30/18

to web...@googlegroups.com

Sorry I tried to clarify by my new question :

If I have a column with data like db.persons with data like

Carl

Junior

Maggie

Tom

Derrick

And each column name has other fields with data such as:

persons.name	persons.age	persons.location	persons.occupation	persons.interests
Carl	23	London	Neuroscientist	brainy stuff
Junior	25	Tokyo	doctor	medical research
Maggie	33	Nairobi	farmer	GMO research
Tom	25	Sydney	teacher	educational ideas
Derrick	21	Chicago	surgeon	Cutting through

I want to iterate through the column persons.nameand randomly pick a name and using the rows object, display all data about the person.

If I do

rows_name = db().select(db.persons.name).column()

rows = db(db.persons.ALL).select()
for row in rows:
    if rows_name[0] == 'Maggie':
        for row in rows:
                return [row.age+' '+row.location+' '+row.occupation+' '+row.interests]

The problem is that if I query 'Carl' which is the first item, I get the response but I cant query any other name .

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/topic/web2py/ynBOuIdufso/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

I had been using python isle to test some modules. Now I just want to get a clearer code by removing the long codes.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

Richard Vézina

unread,

Apr 30, 2018, 1:38:01 PM4/30/18

to web2py-users

The above should be :

fields = db.persons.fields

# You should have in fields a list of all fields names you migth want to remove "id" field by filtering it or find index and pop it out of the list

# ex.: fields.pop(fields.index('id'))

rows = db(db.persons.ALL).select()

db(where_clause).select(fields_name_separated_by_comma)

The above is completly wrong as you pass the fields instead of specifying your where clause parameter...

In you example you really only need select like this :

def some_func_name()

rows = db(db.persons.id > 0).select(db.persons.ALL)

rows_values = []

for row in rows:

row_value = []

for f, v in row:

if f != 'id':

row_value.append(v)

rows_values.append(row_value)

return rows_values

ret = some_func_name()

for r in ret:

print(' '.join(ret))

I didn't tested it but the above should work...

Good luck

for row in rows:   if rows_name[0] == 'Maggie':   for row in rows:   return [row.age+' '+row.location+' '+row.occupation+' '+row.interests]

The problem is that if I query 'Carl' which is the first item, I get the response but I cant query any other name .
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/topic/web2py/ynBOuIdufso/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

Maurice Waka

unread,

Apr 30, 2018, 1:49:09 PM4/30/18

to web...@googlegroups.com

Thank you. Let me work on it.

Regards

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

Maurice Waka

unread,

Apr 30, 2018, 11:39:25 PM4/30/18

to web...@googlegroups.com

What would f, v be.

I get this error : ValueError : too many values to unpack

On Mon, 30 Apr 2018, 20:38 Richard Vézina <ml.richa...@gmail.com> wrote:

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

Richard Vézina

unread,

May 1, 2018, 9:44:21 AM5/1/18

to web2py-users

for f, v in row:

Should be

for f, v in row.iteritems():

k, v for key, value, but I use f instead of k because you will have field_name and value in this for loop...

Richard

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

Maurice Waka

unread,

May 1, 2018, 11:22:56 AM5/1/18

to web...@googlegroups.com

Thanks.

It iterates well giving some fields data, but not all as needed. I get data from some 4 fields only. I have about 60 in some db. Plus there is this:

<pydal.helpers.classes.recordupdater>

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

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 web2py+un...@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Richard Vézina

unread,

May 1, 2018, 11:52:22 AM5/1/18

to web2py-users

Are you querying multiple table?? You can do a join... That way you will have all the value for every fields the only catch is that when you join to disambiguate fields names dal use table.field instead of just field as field name so it migth happen that if you call "manually" vs "programmatically" you field you forgot about that... You have to do db.table['table.field']...

Richard

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 web2py+unsubscribe@googlegroups.com.

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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/-Hlx1yh-4MU/unsubscribe.

To unsubscribe from this group and all its topics, send an email to web2py+unsubscribe@googlegroups.com.

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 unsu

--

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 web2py+unsubscribe@googlegroups.com.

Richard Vézina

unread,

May 1, 2018, 11:55:04 AM5/1/18

to web2py-users

I really recommand you to go through this book chapiter :

http://web2py.com/books/default/chapter/29/02/the-python-language

You will learn a lot of thing over which you fall right now.

You also can use type(some_python_object) from the shell to understand what you work with... You also can use print and look at the data structure of the raw object before trying to loop over it while expecting a behavior but forgot that you iterate over a dict and not list for instance...

Richard

Maurice Waka

unread,

May 1, 2018, 2:03:00 PM5/1/18

to web...@googlegroups.com

Thanks. Doing that already.

To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.

<pre class="m_-3733297408904191050m_6143588816043257

Reply all

Reply to author

Forward