Revision 174fe30e
Von Moritz Bunkus vor fast 17 Jahren hinzugefügt
| SL/IC.pm | ||
|---|---|---|
| 1690 | 1690 |
$query = |
| 1691 | 1691 |
qq|SELECT l.id, l.description, tr.translation, tr.longdescription |
| 1692 | 1692 |
FROM language l |
| 1693 |
LEFT OUTER JOIN translation tr ON (tr.language_id = l.id) AND (tr.parts_id = ?)|; |
|
| 1693 |
LEFT OUTER JOIN translation tr ON (tr.language_id = l.id) AND (tr.parts_id = ?) |
|
| 1694 |
ORDER BY lower(l.description)|; |
|
| 1694 | 1695 |
@values = (conv_i($form->{id}));
|
| 1695 | 1696 |
|
| 1696 | 1697 |
} else {
|
| 1697 |
$query = qq|SELECT id, description FROM language|; |
|
| 1698 |
$query = qq|SELECT id, description |
|
| 1699 |
FROM language |
|
| 1700 |
ORDER BY lower(description)|; |
|
| 1698 | 1701 |
} |
| 1699 | 1702 |
|
| 1700 | 1703 |
my $languages = selectall_hashref_query($form, $dbh, $query, @values); |
Auch abrufbar als: Unified diff
Sprachen alphabetisch sortieren.