Re: retrieve_all and order by

[prev] [thread] [next] [Date index for 2005/01/27]

On Thu, Jan 27, 2005 at 12:35:08PM +0100, Hartmaier Alexander wrote:
> 
> I need to retrieve all objects from a table and display them ordered by
> a column.
> 
> For speed I use the iterator version:
> 
> @interfaces = NAC::Interface->retrieve_all();

This isn't the iterator version, this would give you an array
containing all the retrieved objects.

> 
> But retrieve_all doesn't provide a way to sort the objects ;-(
> 
> 

You want Class::DBI::Plugin::RetrieveAll, which allows more complex
queries.

http://search.cpan.org/~tmtm/Class-DBI-Plugin-RetrieveAll-1.01/
 
I can recommend reading the list archives, checking the wiki at
http://www.class-dbi.com/ and also using http://search.cpan.org/. This
topic has come up quite a few times before.

Stephen