comparison 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
comparison
equal deleted inserted replaced
5476:f9eee1909e6e 5479:11fba4dabe05
50 select.gauge.master.discharge.table = \ 50 select.gauge.master.discharge.table = \
51 SELECT \ 51 SELECT \
52 dt.id AS id, \ 52 dt.id AS id, \
53 dt.bfg_id AS bfg_id \ 53 dt.bfg_id AS bfg_id \
54 FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \ 54 FROM discharge_tables dt JOIN gauges g ON dt.gauge_id = g.id \
55 WHERE g.id = :gauge_id AND g.kind = 0 55 WHERE g.id = :gauge_id AND dt.kind = 0
56 update.bfg.id.discharge.table = \ 56 update.bfg.id.discharge.table = \
57 UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id 57 UPDATE discharge_tables SET bfg_id = :bfg_id WHERE id = :id

http://dive4elements.wald.intevation.org