Re: [CDBI] simplest way to do WHERE stuff

[prev] [thread] [next] [Date index for 2005/11/29]

Quick question: I'm doing a lot of stuff like this with
Class::DBI::AbstractSearch:

@i = My::Foo->search_where
  ({ '-or' => [ 'foo' => 'x', 'bar' => 'x' ] });

...which throws an error using Sweet (can't find column
'-or'). Is there a Sweet-ism for doing OR searches that I'm
missing?

____________________________________________________________
Eamon Daly



----- Original Message ----- 
From: "Matt S Trout" <dbix-class@xxxxx.xx.xx>
To: "Peter Speltz" <peterspeltz@xxxxx.xxx>
Cc: <classdbi@xxxxx.xxxxxxxxxxxxxxxx.xxx>
Sent: Tuesday, November 29, 2005 11:08 AM
Subject: Re: [CDBI] simplest way to do WHERE stuff


> On Mon, Nov 28, 2005 at 09:09:19PM -0600, Peter Speltz wrote:
>> The simplest is Class::DBI::AbstractSearch. From synopsis:
>>
>> my @music = CD::Music->search_where(
>>       artist => [ 'Ozzy', 'Kelly' ],
>>       status => { '!=', 'outdated' },
>>   );
>
> Which will work identically under Sweet, except you can simply do ->search
> and it all works ...
>
> So far as I'm concerned Sweet 0.01 (which I had nothing to do with :)
> obsoleted the various extant Abstract plugins.


_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi