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 Maypole-users@lists.sourceforge.net 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 Maypole-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/maypole-users