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)] })
I'm throwing that out from memory...
--
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]
