Thanks Anthony, that was exactly what I was looking for. On Fri, Jan 20, 2012 at 1:33 PM, Anthony <abasta...@gmail.com> wrote:
> 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://ca.linkedin.com/in/brucelwade> >> http://www.wadecybertech.com >> http://www.warplydesigned.com >> http://www.**fitnessfriendsfinder.com<http://www.fitnessfriendsfinder.com> >> > -- -- Regards, Bruce Wade http://ca.linkedin.com/in/brucelwade http://www.wadecybertech.com http://www.warplydesigned.com http://www.fitnessfriendsfinder.com
