On Thu, Oct 1, 2009 at 3:22 PM, Cory Watson <[email protected]> wrote: > On Thu, Oct 1, 2009 at 3:18 PM, Dermot <[email protected]> wrote: >> Hi, >> >> I suspect the answer to the question, "can I use >> DBIx::Class::Resultset to do a sql query like this": >> >> SELECT * FROM countries where iso2letter NOT IN ('GB','IE', 'HK','US'); > > Isn't it just: > > ->search({ iso2letter => { '-not-in' => [qw(GB IE HK US)] })
Er, Rob's response is right. That's not_in. (underscore) -- Cory 'G' Watson http://www.onemogin.com _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
