Hello
i have a table with integer field.
i populated thhe db from a csv (created from other then me).
it sometimes has empty value for the integers fields.
So when i try to get a list of the records of the table, i got:
type 'exceptions.ValueError'> invalid literal for long() with base 10: ''
from db.py #table prodotti
Field("lunghezza","integer"),
Field("larghezza","integer"),
from default.py
prodotti = legacy_db().select(legacy_db.prodotti.ALL,orderby='prodotti.id
DESC', limitby=limitby)
The error ticket:
File
"/home/marcello/scripts/web2py/2/web2py/applications/PROVE/controllers/default.py",
line 171, in lista_prodotti
prodotti =
legacy_db().select(legacy_db.prodotti.ALL,orderby='prodotti.id DESC',
limitby=limitby)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/objects.py",
line 2026, in select
return adapter.select(self.query,fields,attributes)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/sqlite.py",
line 125, in select
return super(SQLiteAdapter, self).select(query, fields, attributes)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1239, in select
return self._select_aux(sql,fields,attributes)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1220, in _select_aux
return processor(rows,fields,self._colnames,cacheable=cacheable)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1596, in parse
value = self.parse_value(value,ft,blob_decode)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1450, in parse_value
return self.parsemap[key](value,field_type)
File
"/home/marcello/scripts/web2py/2/web2py/gluon/packages/dal/pydal/adapters/base.py",
line 1534, in parse_integer
return long(value)
ValueError: invalid literal for long() with base 10: ''
how to face with empty values?
--
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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
