did you ever change the type of the field? If so this is a sqlite problem since it does not allow alter table and does not enfore type. say the field was an int, you stored an int, then you changed the type to a string, sqlitke keeps the data as int. Now web2py thinks is a string and sqlite stores an int.
do not change field types in sqlite if you have data stored. Massimo On Feb 3, 7:53 am, notabene <[email protected]> wrote: > I am still mystified, but found a Work around by: > exporting, deleting and importing csv-file > > On Feb 3, 8:36 am, notabene <[email protected]> wrote: > > > record from arrdato: > > arrdato.id arrdato.uuid arrdato.arrid arrdato.stedid > > arrdato.arrangid > > arrdato.postnr > > 1190 1190 2 1 > > 3 3740 > > > I can select it by id, uuid and postnr, but not by: > > arrid,stedid,arrangid! > > > The problematic fields are defined as: db.Field > > ('xxx','string',length=64) > > > Query e.g. db.arrdato.arrid=='2' or > > db.arrdato.arrid==2 > > results: 0 selected --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
