From: David
Hi,
is not possible to set 'not equal' using ResultSet search method? I can't
make it with 'search_literal' method because I need to use a join clause too.
I would like to do something like:
$c->model('DB::Test')->search({-and => [ 'me.name' => 'name', -not => {
'users.id' => 'id'}]},
{ join => 'users' });
If you want to use -and, you can skip it. If you'll want to use the same
table/column in 2 expressions you can add it back.
Try something like:
$c->model('DB::Test')->search({
'me.name' => 'name',
'users.id' => {'!=' => 'id'},
},{
join => 'users',
});
Octavian
__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4933 (20100310) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/
