I just downloaded the windows version and I think this issue still continues in that version.
On Jan 31, 3:22 pm, vortex <billyara...@gmail.com> wrote: > It has been reported as issue 172. > > On Jan 31, 2:56 pm,vortex<billyara...@gmail.com> wrote: > > > I will do that now. > > > Thanks. > > > On Jan 31, 2:27 pm, Massimo Di Pierro <massimo.dipie...@gmail.com> > > wrote: > > > > You found a bug. What is the model? > > > > Can you post the model (just relevant field) and this example as an > > > issue in google code. I will fix it asap. > > > > Massimo > > > > On Jan 31, 7:42 am,vortex<billyara...@gmail.com> wrote: > > > > > More info on this: > > > > > the (db.read.of_section != db.item.of_section) part is translating > > > > into: > > > > > (rfid_read.of_section IS NOT NULL) > > > > > On Jan 31, 1:26 pm,vortex<billyara...@gmail.com> wrote: > > > > > > SELECT * FROM item JOIN read on read.of_item=item.id WHERE > > > > > item.of_section <> read.of_section > > > > > > I tried: > > > > > > db((db.item.id == db.read.of_of_item) & (db.read.of_section != > > > > > db.item.of_section)).select() > > > > > > but I don't want a join. I just want the where cause to be: > > > > > (db.read.of_section != db.item.of_section). > >