2009/10/1 Cory Watson <[email protected]>: > 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)] })
Thanx for putting me straight on that. Is this construct within search() from SQL::Abstract? I can't see it within the DBIx::Class docs. Dp. _______________________________________________ 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]
