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.name and 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 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.
