Kim,
I am not sure how you populate the list but if you modify your has_a
declaration to
MyApp::Orders->has_a(fruit_id => "MyApp::Fruits",{order_by=>'fruit_name'});
it should do the trick.
Regards
Ian
>>> Kim Ryan <[EMAIL PROTECTED]> 13/07/06 4:11 PM >>>
Hi Ian,
I added in the order sub. If I simply list my fruit table,
it is sorted alphabetically by fruit name which is good.
The problem occurs when another table just stores the fruit id,
and I join across to the fruit table to replace the id with
the full name.
For example in table orders
quantity fruit_id
10 2
5 1
4 3
MyApp::Orders->has_a(fruit_id => "MyApp::Fruits");
A select list built from fruit_id will still display
Apple
Banana
Pear
Orange
even with an order sub in place for fruits
Regards,
Kim
Ian VanDerPoel wrote:
>Kim,
>
>You need to overide the ORDER method for that table. Something like:
>
>sub order {
> my ($self, $r) = @_;
> return ($self->SUPER::order($r) || 'fruit' );
>}
>
>I hope this makes sense.
>
>Regards
>
>Ian
>
>
>
>
>>>>Kim Ryan <[EMAIL PROTECTED]> 13/07/06 3:37 PM >>>
>>>>
>>>>
>HI all,
>
>I have some fairly long select lists to display. I use the has_a
>method so the contents of the select list are drawn from a database table.
>When I initially create the table I can control the sort sequence, such as
>
>Apple, value = 1
>Banana, value = 2
>Pear, value = 3
>.....
>
>and they will appear in that order. A problem occurs when I
>want to add "Orange, value =4", it will be at the end of the list.
>
>Is there a way to have select lists sorted alphabetically?
>
>Thanks,
>
>Kim
>
>
>
>
>
>
>
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users
_____________________________________________________________________
This message (including any attachments) is intended solely for the addressee
named and may contain confidential and or privileged information. If you are
not the intended recipient, please delete it and notify the sender. Views
expressed in this message are those of the individual sender, and are not
necessarily the views of the Ministry of Transport (MoT) or The Independent
Transport Safety Reliability Regulator (ITSRR) or The Office of Transport
Safety Investigation (OTSI). Whole or parts of this e-mail may be subject to
copyright of the Ministry or third parties. You should only re-transmit,
distribute or use the material for commercial purposes if you are authorised to
do so.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users
