That makes sense. I had changed the 'meaning' of mtref into int, without changing its type. Forgot about that.
Thanks! On Apr 12, 5:50 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > Sure that db.participant.mtref is not a string? What is the type? > > On Apr 12, 6:33 pm, Sven <svenstrin...@gmail.com> wrote: > > > > > Hi, > > > I was just using the default db admin page in web2py and filled in > > 'db.participant.mtref > 41' as a query for my participant table. > > Surprisingly it returned (this is just part of the output on the > > screen): > > > participant.id participant.mtref > > 22149 8 > > > It returns 49 records, 9 of which have a participant.mtref < 41 > > > any idea how this is possible? > > > Sven -- To unsubscribe, reply using "remove me" as the subject.