Yes, it really acts like str. I'm using the nightly build 1.99.7 dev. Could 
it be because of dev?

here's all of the db definition:

db.define_table('company',
    Field('title', label='Pavadinimas', unique=True),
    Field('CEO', label='Generalinis dir.'),
    Field('code', 'integer', label='Įmonės kodas',unique=True, 
default=None),
    Field('revenue', 'integer', label='Metinė apyvarta'),
    Field('workers', 'integer', label='Darbuotojų skaičius'),
    # Field('logo', 'upload', label='Įmonės logo'),
    Field('produce_tag', db.tag, 'list:string', label='Produkcija', 
default=None),
    Field('produce', label='Produkcija (smulkiau)'),
    Field('Email', default=None, notnull=False),
    Field('Tel'),
    Field('Fax'),
    Field('www'),
    Field('City', db.city, 'list:reference city', label='Miestas'),
    Field('address', label='Adresas'),
    Field('extra_contacts', 'boolean', label='Pridėti kontakt. duomenų'),
    Field('extra_contacts_2', 'boolean', label='Pridėti kontakt. duomenų'),
    Field('name_1', label='Vardas'),
    Field('pareigos_1', label='Pareigos'),
    Field('tel_1', label='Papildomas tel.'),
    Field('email_1', label='Papildomas el. paštas'),
    Field('name_2', label='Vardas'),
    Field('pareigos_2', label='Pareigos'),
    Field('tel_2', label='Papildomas tel.'),
    Field('email_2', label='Papildomas el. paštas'),
    Field('Association',  db.asoc, label='Priklauso asociacijai'),
    Field('other', 'text', label='Papildoma info'),
    Field('submited_at', 'datetime', default=request.now, writable=False, 
readable=False),
    Field('submited_by', db.auth_user, default=auth.user_id, 
writable=False, readable=False),
    Field('updated_at', 'datetime', update=request.now, writable=False, 
readable=False),
    Field('updated_by', db.auth_user, update=auth.user_id, writable=False, 
readable=False),
    Field('exports_wants_to', 'list:reference countries', label='Domina 
šalys'),
  #  Field('exports_or_not', 'boolean', label = 'Ar eksportuoja?'),
    Field('exports_to', 'list:reference countries', label='Eksportuoja į', 
required=False),
  #  Field('imports_or_not', 'boolean', label = 'Ar Importuoja?'),
    Field('imports_from', 'list:reference countries', label='Importuoja 
iš', required=False),
    format = '%(title)s')

in order to test the selection, I use web2py DB environment. Query: 
db.company.workers<40
acts like comparing strings.. wonder why :/




On Tuesday, July 17, 2012 9:37:20 AM UTC+3, pbreit wrote:
>
> Looks like it is comparing them as strings. As others noted, need to see 
> code.

-- 



Reply via email to