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?
>
