Mercurial > dive4elements > river
changeset 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 | f9eee1909e6e |
children | 7a68967ca72a |
files | flys-aft/src/main/resources/sql/flys-common.properties |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
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