How about: db(~db.table.id.belongs([2, 10, 5, 8])).select()
Anthony On Friday, January 20, 2012 4:23:03 PM UTC-5, Detectedstealth wrote: > > Hi, > > How can I make web2py query for all results that are not in a list of ids? > > IE: > > dont_want_ids_to_be_returned = ['2','10','5','8'] > > db(db.table.ids_not_in(dont_want_ids_to_be_returned)).select() > > I want the select to return everything except the records with the ids > found in dont_want_ids_to_by_returned. > > -- > -- > Regards, > Bruce Wade > http://ca.linkedin.com/in/brucelwade > http://www.wadecybertech.com > http://www.warplydesigned.com > http://www.fitnessfriendsfinder.com >
