Kim,
We do it here by overiding the list function and then doing a perl sort.
I just saw Peters post. Thanks Peter.
We are still on Maypole 2.06 so maybe my suggestions are outdated. Need to move
to 2.11 as soon as I have some time.
>>> Kim Ryan <[EMAIL PROTECTED]> 14/07/06 10:07 AM >>>
Yes that's it. I know I can achieve this ordering with SQL:
select order.quantities, fruits.name from orders,fruit
where orders.fruit_id = fruits.id
order by fruits.name
Can see this is more difficult. But given that Class::DBI is
already joining the two tables, is it also able to sort by
a column in the outer table (name)?
Kim
Ian VanDerPoel wrote:
>Kim,
>
>OK, I think I get it. The orders table only has the ID in it, but you want it
>to order by the description held in the Fruits table.
>
>If that is the case, it is a lot more difficult to do. Are you saying that you
>want the orders "list" to display sorted by fruit name?
>
>
>
>>>>Kim Ryan <[EMAIL PROTECTED]> 14/07/06 9:43 AM >>>
>>>>
>>>>
>Tried that. The Fruits table displays correctly, by name order.
>But Fruit names in the quantity table are still ordered by id.
>
>Kim
>
>Ian VanDerPoel wrote:
>
>
>
>>Kim,
>>
>>Sorry Kim, I have specified this incorrectly. I was not thinking straight.
>>The has_many has the order_by clause. The original fix that I posted should
>>work. You just need to modify it to suit your code.
>>
>>You need to overide the "order" method in table Fruits with
>>
>>sub order { return ( 'name' ); } # as in name = the column name in Fruits
>>
>>I hope this works.
>>
>>
>>
>>
>>
>>>>>Kim Ryan <[EMAIL PROTECTED]> 14/07/06 8:51 AM >>>
>>>>>
>>>>>
>>>>>
>>>>>
>>Tried that but the sort order is still not what I want. This applies
>>both to a select list, and listing a table with a has_a join. Results
>>still sorted by the id of the join and not the name.
>>
>>Thanks,
>>
>>Kim
>>
>>Ian VanDerPoel wrote:
>>
>>
>>
>>
>>
>>>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
>>>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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>_____________________________________________________________________
>>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
>>
>>
>>
>>
>>
>>
>
>
>
>_____________________________________________________________________
>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
>
>
>
>
_____________________________________________________________________
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
