Re: retrieve_all and order by

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

Thanks a lot!

-Alex


-----Urspr=FCngliche Nachricht-----
Von: Stephen Quinney [mailto:stephen.quinney@xxxxxxxxxxxxxxxxxx.xxxxxx.xx=
=2Euk]=20
Gesendet: Donnerstag, 27. Januar 2005 12:40
An: Class:DBI maillist
Betreff: Re: retrieve_all and order by

On Thu, Jan 27, 2005 at 12:35:08PM +0100, Hartmaier Alexander wrote:
>=20
> I need to retrieve all objects from a table and display them ordered by=

> a column.
>=20
> For speed I use the iterator version:
>=20
> @interfaces =3D NAC::Interface->retrieve_all();

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

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

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

http://search.cpan.org/~tmtm/Class-DBI-Plugin-RetrieveAll-1.01/
=20
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


*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*"*
Hinweis: Dieses E-mail kann vertrauliche und gesch=FCtzte Informationen e=
nthalten.
Sollten Sie nicht der beabsichtigte Empf=E4nger sein, verst=E4ndigen Sie =
bitte den Absender und l=F6schen Sie dieses E-mail dann sofort.

Notice: This e-mail contains information that is confidential and may be =
privileged.
If you are not the intended recipient, please notify the sender and then =
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*=
"*"*