http://search.cpan.org/dist/SQL-Abstract/lib/SQL/Abstract.pm#Special_operators_:_IN,_BETWEEN,_etc . Justin
On Thu, Oct 1, 2009 at 2:26 PM, Dermot <[email protected]> wrote: > 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] >
_______________________________________________ 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]
