[Dbix-class] Re: search NOT IN

[Stuart Dodds]

> On Mon, Jul 06, 2009 at 04:26:27PM +0200, Stuart Dodds wrote:
> > For example, the sql I would like to produce is as follows:
> > 
> > WHERE id NOT IN (?,?,?)
>
> Assuming you use a recent version of SQL::Abstract, see:
> http://search.cpan.org/~ribasushi/SQL-Abstract-1.56/lib/SQL/Abstract.pm#Special_operators_:_IN,_BETWEEN,_etc.
>
> Tom


Ahh that's where it's hiding....thanks for your help.

Stuart.


_______________________________________________
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/dbix-class@lists.scsys.co.uk