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 <[email protected]> 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 <[email protected]> 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).
