On Thu, Oct 1, 2009 at 16:18, 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');
$countries_rs->search({ iso2letter => { -not_in => [ 'GB', 'IE', 'HK',
'UK' ] } });
You'll need a reasonably new DBIx::Class.
--
Thanks,
Rob Kinyon
_______________________________________________
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]
