Hello wuelfhis, Do you have 1.99.7 stable? I believe this has been fixed in trunk and in the nightly build. Can you try it?
Massimo On Wednesday, May 16, 2012 4:42:55 PM UTC-5, wuelfhis asuaje wrote: > > It only happens in version 1.99.7 > > in 1.99.1 works perfect > > Only happens when the table or (i don't know if model) has a float or > decimal field > > That's what i ran: > > In [66]: rows = db().select(db.fc_pago.ALL) > --------------------------------------------------------------------------- > KeyError Traceback (most recent call last) > /home/wasuaje/Documentos/desarrollo/web2py2/applications/flota/models/plugin_jqgrid.py > > in <module>() > ----> 1 rows = db().select(db.fc_pago.ALL) > > /home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in select(self, > *fields, **attributes) > 7576 adapter = self.db._adapter > 7577 fields = adapter.expand_all(fields, > adapter.tables(self.query)) > -> 7578 return adapter.select(self.query,fields,attributes) > 7579 > 7580 def delete(self): > > /home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in select(self, > query, fields, attributes) > 1318 limitby = attributes.get('limitby', None) or (0,) > 1319 rows = self.rowslice(rows,limitby[0],None) > -> 1320 return self.parse(rows,fields,self._colnames) > 1321 > 1322 def _count(self, query, distinct=None): > > /home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in parse(self, > rows, fields, colnames, blob_decode) > 1615 colset = new_row[tablename] > 1616 colset[fieldname] = value = \ > -> 1617 > self.parse_value(value,field.type,blob_decode) > 1618 > 1619 if field.type == 'id': > > /home/wasuaje/Documentos/desarrollo/web2py2/gluon/dal.pyc in > parse_value(self, value, field_type, blob_decode) > 1494 else: > 1495 key = regex_type.match(field_type).group(0) > -> 1496 return self.parsemap[key](value,field_type) > 1497 > 1498 def parse_reference(self, value, field_type): > > KeyError: 'float' > > > my model > #-------- > db.define_table('fc_pago', > Field('id','integer'), > Field('fecha','date'), > Field('total','double'), #tryed with decimal or float here in mysql is > float > Field('descripcion','string'), > Field('mt_persona_id','integer'), > migrate=False) > > db.fc_pago.mt_persona_id.requires = IS_IN_DB(db,db.mt_persona.id,'%(nombres)s > %(apellidos)s' ) > db.fc_pago.mt_persona_id.represent=lambda val: db.mt_persona[val].nombres > > > > Database Mysql > > mysql Ver 14.14 Distrib 5.5.22, for debian-linux-gnu (i686) using > readline 6.2 > > What's going on here? >