Index: openacs-4/packages/contacts/lib/contacts.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/lib/contacts.tcl,v
diff -u -r1.28 -r1.29
--- openacs-4/packages/contacts/lib/contacts.tcl	20 Oct 2005 22:52:33 -0000	1.28
+++ openacs-4/packages/contacts/lib/contacts.tcl	21 Oct 2005 10:54:12 -0000	1.29
@@ -83,12 +83,18 @@
 switch $orderby {
     "first_names,asc" {
         set name_label "[_ contacts.Sort_by]: [_ contacts.First_Names] | <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {last_name,asc}}}]\">[_ contacts.Last_Name]</a> | <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {organization,asc}}}]\">[_ contacts.Organization]</a>"
+	set left_join "left join persons on (parties.party_id = persons.person_id)"
+	set sort_item "lower(first_names)"
     }
     "last_name,asc" {
         set name_label "[_ contacts.Sort_by] <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {first_names,asc}}}]\">[_ contacts.First_Names]</a> | [_ contacts.Last_Name] | <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {organization,asc}}}]\">[_ contacts.Organization]</a>"
+	set left_join "left join persons on (parties.party_id = persons.person_id)"
+	set sort_item "lower(last_name)"
     }
     "organization,asc" {
         set name_label "[_ contacts.Sort_by] <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {first_names,asc}}}]\">[_ contacts.First_Names]</a>  | <a href=\"[export_vars -base $base_url -url {format search_id query page page_size {orderby {last_name,asc}}}]\">[_ contacts.Last_Name]</a> | [_ contacts.Organization]"
+	set left_join "left join organizations on (parties.party_id = organizations.organization_id)"
+	set sort_item "lower(organizations.name)"
     }
 }