full dashboard sorting
authorAndrew Dunstan <andrew@dunslane.net>
Tue, 27 Mar 2007 15:59:05 +0000 (15:59 +0000)
committerAndrew Dunstan <andrew@dunslane.net>
Tue, 27 Mar 2007 15:59:05 +0000 (15:59 +0000)
cgi-bin/show_status.pl

index 3816185a77b01c48663df5465a1b0991853934e7..ee3c826bc14d0d79b7eed93cd403af213e766780 100644 (file)
@@ -23,15 +23,15 @@ my $sort_clause = "";
 my $sortby = $query->param('sortby') || 'nosort';
 if ($sortby eq 'name')
 {
-       $sort_clause = 'sysname,';
+       $sort_clause = 'lower(sysname),';
 }
 elsif ($sortby eq 'os')
 {
-       $sort_clause = 'operating_system, os_version desc,'; 
+       $sort_clause = 'lower(operating_system), os_version desc,'; 
 }
 elsif ($sortby eq 'compiler')
 {
-       $sort_clause = "compiler, compiler_version,";
+       $sort_clause = "lower(compiler), compiler_version,";
 }
 
 my $db = DBI->connect($dsn,$dbuser,$dbpass) or die("$dsn,$dbuser,$dbpass,$!");