Hi,
I have declared a table 'company' and the Field 'workers' which expects the
number of workers in the company:
db.define_table('company',
(...)
Field('workers', 'integer'),
The problem arrises when I want to do some computations with this field,
for instance select some row. Strange stuff happens.
Let's say I have 4 entries/rows:
db.compny.workers
id 1 5
id 2 6
id 3 12
id 4 40
When I run a query *db.company.workers>0 *the results are fine
(4 displayed),
When I run *db.company.workers<38 *only the id 3 (12 workers) is shown.
*db.company.workers<100 *gives *none* results.
*db.company.workers>5 *gives only 6
I have absolutely no clue what is going on. Thnx