Hi,
<query> ORDER BY priority
should do it..
Grtz,
Michel
On Wed, 21 Nov 2001, Markus Garscha wrote:
> hi!
>
> i have a 1:n relation, a "person" who has multiple "phone"-numbers. each
> phonenumber as a field "priority" of type integer which is used for sorting
> the phonenumbers.
>
> the problem: when i query a person (with all its numbers), the numbers are
> random.
>
> how to order the phonenumbers per person by priority?
>
>
> cu
> markus
>
> --
> -------------------------------------------------------------------------------
> Markus Garscha email: [EMAIL PROTECTED]
> Hartmannstr. 129 fon: 09131/626715
> 91058 Erlangen fax: +49 89 244356966
> pgp-keyid: 0xEE18AF3B
> -------------------------------------------------------------------------------
>
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
