Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 3913:bdf855b5693f | 3914:729bd242c82e |
|---|---|
| 83 " JOIN station s" + | 83 " JOIN station s" + |
| 84 " ON m.stationid = s.stationid " + | 84 " ON m.stationid = s.stationid " + |
| 85 " JOIN gewaesser g " + | 85 " JOIN gewaesser g " + |
| 86 " ON s.gewaesserid = g.gewaesserid " + | 86 " ON s.gewaesserid = g.gewaesserid " + |
| 87 "WHERE" + | 87 "WHERE" + |
| 88 " g.name = :name " + | 88 " g.name = :name AND " + |
| 89 " m.km IS NOT NULL " + | |
| 89 "ORDER by" + | 90 "ORDER by" + |
| 90 " m.km, m.datum"; | 91 " m.km, m.datum"; |
| 91 | 92 |
| 92 protected String riverName; | 93 protected String riverName; |
| 93 | 94 |