Mercurial > dive4elements > river
diff flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java @ 3914:729bd242c82e
MINFO: Fixed SQL statement in BedloadOverview. Exclude data where km is null.
flys-artifacts/trunk@5584 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Raimund Renkert <raimund.renkert@intevation.de> |
---|---|
date | Mon, 24 Sep 2012 09:10:42 +0000 |
parents | 35a6c9a49a76 |
children |
line wrap: on
line diff
--- a/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java Mon Sep 24 08:36:33 2012 +0000 +++ b/flys-artifacts/src/main/java/de/intevation/flys/artifacts/model/minfo/BedloadOverview.java Mon Sep 24 09:10:42 2012 +0000 @@ -85,7 +85,8 @@ " JOIN gewaesser g " + " ON s.gewaesserid = g.gewaesserid " + "WHERE" + - " g.name = :name " + + " g.name = :name AND " + + " m.km IS NOT NULL " + "ORDER by" + " m.km, m.datum";