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
>
>
>
>
-------------------------------------------------------------------------
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
