Index: openacs-4/packages/file-storage/www/search-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/search-oracle.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/file-storage/www/search-oracle.xql 17 Aug 2001 01:24:17 -0000 1.1 +++ openacs-4/packages/file-storage/www/search-oracle.xql 30 Apr 2018 07:57:40 -0000 1.2 @@ -3,7 +3,7 @@ oracle8.1.6 - + select item_id as file_id, Index: openacs-4/packages/file-storage/www/search-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/search-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/file-storage/www/search-postgresql.xql 17 Aug 2001 01:24:34 -0000 1.1 +++ openacs-4/packages/file-storage/www/search-postgresql.xql 30 Apr 2018 07:57:40 -0000 1.2 @@ -3,7 +3,7 @@ postgresql7.1 - + select item_id as file_id, Index: openacs-4/packages/file-storage/www/search.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/search.tcl,v diff -u -r1.5 -r1.6 --- openacs-4/packages/file-storage/www/search.tcl 7 Aug 2017 23:48:11 -0000 1.5 +++ openacs-4/packages/file-storage/www/search.tcl 30 Apr 2018 07:57:40 -0000 1.6 @@ -26,7 +26,7 @@ set query "%${query}%" regsub -all {%+} $query {%} query -db_multirow results results {} +db_multirow results get_ids_and_titles {} # get the (lowercased) original back to feed to the template