diff options
| author | fisharebest <fisharebest@gmail.com> | 2011-10-23 15:44:01 +0000 |
|---|---|---|
| committer | fisharebest <fisharebest@gmail.com> | 2011-10-23 15:44:01 +0000 |
| commit | 0f60657c73d0846b9defd781d4d536062fab75d8 (patch) | |
| tree | 3a21ef5515c4cfa62f75da344baf56f710c31d55 | |
| parent | 55e3db2ae3670469eafaeaebff5e8ef0be6e3954 (diff) | |
| download | webtrees-0f60657c73d0846b9defd781d4d536062fab75d8.tar.gz webtrees-0f60657c73d0846b9defd781d4d536062fab75d8.tar.bz2 webtrees-0f60657c73d0846b9defd781d4d536062fab75d8.zip | |
#880404 - Hebrew Indi- & Fam-list top letters
| -rw-r--r-- | library/WT/Query/Name.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/library/WT/Query/Name.php b/library/WT/Query/Name.php index fb11f83faa..1cf31feee1 100644 --- a/library/WT/Query/Name.php +++ b/library/WT/Query/Name.php @@ -229,9 +229,9 @@ class WT_Query_Name { } // Now fetch initial letters that are not in our alphabet, - // including "@" (for "@N.N.") and "" for no surname + // including "@" (for "@N.N.") and "" for no surname. $sql= - "SELECT LEFT(n_surn, 1), COUNT(n_id)". + "SELECT UPPER(LEFT(n_surn, 1)), COUNT(n_id)". " FROM `##name` ". ($fams ? " JOIN `##link` ON (n_id=l_from AND n_file=l_file AND l_type='FAMS') " : ""). " WHERE n_file={$ged_id} AND n_surn<>''". @@ -301,7 +301,7 @@ class WT_Query_Name { // Now fetch initial letters that are not in our alphabet, // including "@" (for "@N.N.") and "" for no surname $sql= - "SELECT LEFT(n_givn, 1), COUNT(DISTINCT n_id)". + "SELECT UPPER(LEFT(n_givn, 1)), COUNT(DISTINCT n_id)". " FROM `##name` ". ($fams ? " JOIN `##link` ON (n_id=l_from AND n_file=l_file AND l_type='FAMS') " : ""). " WHERE n_file={$ged_id} ". |