Mercurial > dive4elements > river
changeset 6622:718b0822374d
CrossSection: Uppercase sql keywords in query.
| author | Felix Wolfsteller <felix.wolfsteller@intevation.de> |
|---|---|
| date | Mon, 22 Jul 2013 11:07:14 +0200 |
| parents | 7e697c6eb379 |
| children | 3999162f474f |
| files | backend/src/main/java/org/dive4elements/river/model/CrossSection.java |
| diffstat | 1 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/backend/src/main/java/org/dive4elements/river/model/CrossSection.java Mon Jul 22 11:03:41 2013 +0200 +++ b/backend/src/main/java/org/dive4elements/river/model/CrossSection.java Mon Jul 22 11:07:14 2013 +0200 @@ -66,8 +66,8 @@ " (SELECT id FROM cross_sections WHERE river_id = :river_id) " + " GROUP BY cross_section_id" + ") cs_ranges " + - "JOIN cross_sections CS on cs_ranges.cross_section_id = cs.id " + - "LEFT OUTER JOIN time_intervals on cs.time_interval_id = time_intervals.id " + + "JOIN cross_sections cs ON cs_ranges.cross_section_id = cs.id " + + "LEFT OUTER JOIN time_intervals ON cs.time_interval_id = time_intervals.id " + "WHERE :km BETWEEN minkm AND maxkm " + "ORDER BY stop_time desc, start_time asc, :km - minkm"; // Order by time interval missing.