diff flys-aft/src/main/resources/sql/flys-common.properties @ 5479:11fba4dabe05

AFT/DIPS: Fixed wrond SQL statement.
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 27 Mar 2013 18:48:28 +0100
parents da1e897c7224
children
line wrap: on
line diff
--- a/flys-aft/src/main/resources/sql/flys-common.properties	Wed Mar 27 17:49:46 2013 +0100
+++ b/flys-aft/src/main/resources/sql/flys-common.properties	Wed Mar 27 18:48:28 2013 +0100
@@ -52,6 +52,6 @@
         dt.id AS id, \
         dt.bfg_id AS bfg_id \
     FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \
-    WHERE g.id = :gauge_id AND g.kind = 0
+    WHERE g.id = :gauge_id AND dt.kind = 0
 update.bfg.id.discharge.table = \
     UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id

http://dive4elements.wald.intevation.org