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). > >