Index: openacs-4/packages/contacts/lib/contacts.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contacts.tcl,v diff -u -r1.44 -r1.45 --- openacs-4/packages/contacts/lib/contacts.tcl 20 Feb 2006 09:06:26 -0000 1.44 +++ openacs-4/packages/contacts/lib/contacts.tcl 27 Feb 2006 03:37:06 -0000 1.45 @@ -106,12 +106,12 @@ "first_names,asc" { set name_label "[_ contacts.Sort_by]: [_ contacts.First_Names] | [_ contacts.Last_Name] | [_ contacts.Organization] | [_ contacts.Last_Modified]" set left_join "left join persons on (parties.party_id = persons.person_id)" - set sort_item "lower(first_names)" + set sort_item "lower(first_names), lower(last_name)" } "last_name,asc" { set name_label "[_ contacts.Sort_by] [_ contacts.First_Names] | [_ contacts.Last_Name] | [_ contacts.Organization] | [_ contacts.Last_Modified]" set left_join "left join persons on (parties.party_id = persons.person_id)" - set sort_item "lower(last_name)" + set sort_item "lower(last_name), lower(first_names)" } "organization,asc" { set name_label "[_ contacts.Sort_by] [_ contacts.First_Names] | [_ contacts.Last_Name] | [_ contacts.Organization] | [_ contacts.Last_Modified]" @@ -310,13 +310,13 @@ } -orderby { first_names { label "[_ contacts.First_Name]" - orderby_asc "lower(first_names) asc" - orderby_desc "lower(first_names) desc" + orderby_asc "lower(first_names) asc, lower(last_name) asc" + orderby_desc "lower(first_names) desc, lower(last_name) desc" } last_name { label "[_ contacts.Last_Name]" - orderby_asc "lower(last_name) asc" - orderby_desc "lower(last_name) desc" + orderby_asc "lower(last_name) asc, lower(first_names) asc" + orderby_desc "lower(last_name) desc, lower(first_names) desc" } organization { label "[_ contacts.Organization]"