Re: Class::DBI::AbstractSearch and order_by, limit...

[prev] [thread] [next] [Date index for 2004/09/01]

On Wed, 1 Sep 2004 at 09:02, Michael Jensen opined:

MJ:I am trying to use Class::DBI::AbstractSearch and it works fine, but I 
MJ:want to figure out how to use order_by and limit (using Rhesa's cool 
MJ:modification). Is it even possible?
MJ:
MJ:        my @obj = Music::Artist->search_where(
MJ:            name => [ 'Ozzy', 'Kelly' ],
MJ:            status => { '!=', 'outdated' },
MJ:			 order_by ... ?
MJ:        );

hi michael - from the class::dbi::abstractsearch docs:

 my @misc = CD::Music->search_where(
             { artist => [ 'Ozzy', 'Kelly' ],
               status => { '!=', 'outdated' } },
             { order_by  => "reldate DESC" }
 );

i've used it many times and it works great.