I've enumerated fields and colnames and they are like this: fields: id text integer string
colnames: city age _id name I believe they don't match and thats why there's this error: File "/opt/web2py/gluon/dal.py", line 8134, in select return adapter.select(self.query,fields,attributes) File "/opt/web2py/gluon/dal.py", line 4711, in select return processor(rows,fields,colnames,False) File "/opt/web2py/gluon/dal.py", line 1681, in parse self.parse_value(value, fields[j].type,blob_decode) File "/opt/web2py/gluon/dal.py", line 1575, in parse_value return self.parsemap[key](value,field _type) File "/opt/web2py/gluon/dal.py", line 1641, in parse_id return int(value) ValueError: invalid literal for int() with base 10: 'Toronto' On Monday, May 7, 2012 11:40:36 PM UTC+1, Massimo Di Pierro wrote: > > Please try again. > > On Monday, 7 May 2012 15:48:04 UTC-5, Francisco Costa wrote: >> >> missing a colon at the end of the line 4677 >> >> if key == 'id' >> >> >> and now I get this error >> >> File "/opt/web2py/gluon/dal.py", line 8134, in select >> return adapter.select(self.query,fields,attributes) >> File "/opt/web2py/gluon/dal.py", line 4711, in select >> return processor(rows,columns,False) >> File "/opt/web2py/gluon/dal.py", line 1675, in parse >> for j,colname in enumerate(colnames): >> TypeError: 'bool' object is not iterable >> >> >> maybe because of the False on line 4711 >> >> >> >> >> On Monday, May 7, 2012 9:27:35 PM UTC+1, Massimo Di Pierro wrote: >>> >>> Thanks for your help and check on this. I just committed a fix in trunk >>> that should address it. Please let me know. >>> >>> On Monday, 7 May 2012 15:19:40 UTC-5, Francisco Costa wrote: >>>> >>>> I think that the mongofields_dict.keys() don't match to the data in the >>>> rows >>>> >>>> mongofields_dict: >>>> id >>>> name >>>> age >>>> city >>>> rows: >>>> Toronto >>>> 66L >>>> 24652490551171733682233802752L >>>> John >>>> >>>> >>>> On Monday, May 7, 2012 8:42:33 PM UTC+1, Massimo Di Pierro wrote: >>>>> >>>>> Your linennumbers do not much the code in trunk. Please try the code >>>>> in trunk. Anyway, something goes wrong in the parse(self, rows, fields, >>>>> colnames, blob_decode=True) function. I suspect mongo does not return the >>>>> columns in the order web2py think it does. Can you print the input of the >>>>> parse function? >>>>> >>>>> On Monday, 7 May 2012 13:20:39 UTC-5, Francisco Costa wrote: >>>>>> >>>>>> So I have this: >>>>>> >>>>>> import sys >>>>>> import time >>>>>> from gluon.dal import DAL, Field >>>>>> mongo = DAL('mongodb://localhost:27017/tymr') >>>>>> mongo.define_table('user', >>>>>> Field('name', 'text'), >>>>>> Field('age', 'integer'), >>>>>> Field('city', 'string') >>>>>> ) >>>>>> >>>>>> def insert_users(): >>>>>> mongo.user.insert(name='John', age=66, city='Toronto') >>>>>> mongo.user.insert(name='Mark', age=43, city='Boston') >>>>>> mongo.user.insert(name='Tom', age=43, city='Detroit') >>>>>> mongo.user.insert(name='Jim', age=18, city='Detroit') >>>>>> mongo.user.insert(name='Jack', age=18) >>>>>> mongo.user.insert(name='Eric', city='Boston') >>>>>> return 'users in database' >>>>>> >>>>>> def find_users(): >>>>>> users = mongo(mongo.user.age==66).select() >>>>>> return dict(users=users) >>>>>> >>>>>> >>>>>> after I run *insert_users* I check in MongoDb via terminal and >>>>>> everything is correct: >>>>>> > db.user.find() >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000000"), "city" : "Toronto", >>>>>> "age" : NumberLong(66), "name" : "John" } >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000001"), "city" : "Boston", >>>>>> "age" : NumberLong(43), "name" : "Mark" } >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000002"), "city" : "Detroit", >>>>>> "age" : NumberLong(43), "name" : "Tom" } >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000003"), "city" : "Detroit", >>>>>> "age" : NumberLong(18), "name" : "Jim" } >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000004"), "age" : >>>>>> NumberLong(18), "name" : "Jack" } >>>>>> { "_id" : ObjectId("4fa80feea34feb34f8000005"), "city" : "Boston", >>>>>> "name" : "Eric" } >>>>>> >>>>>> but when I run *find_users* I get this error: >>>>>> >>>>>> File "/opt/web2py/gluon/dal.py", line 7578, in select >>>>>> return adapter.select(self.query,fields,attributes) >>>>>> File "/opt/web2py/gluon/dal.py", line 4290, in select >>>>>> return self.parse(rows,fields,mongofields_dict.keys(),False) >>>>>> File "/opt/web2py/gluon/dal.py", line 1600, in parse >>>>>> self.parse_value(value, fields[j].type,blob_decode) >>>>>> File "/opt/web2py/gluon/dal.py", line 1496, in parse_value >>>>>> return self.parsemap[key](value,field_type) >>>>>> File "/opt/web2py/gluon/dal.py", line 1562, in parse_id >>>>>> return int(value) >>>>>> ValueError: invalid literal for int() with base 10: 'Toronto' >>>>>> >>>>>> >>>>>>