view flys-aft/src/main/resources/sql/aft-common.properties @ 4255:670e98f5a441

Fixed leak while merging facets. The ThemeList that is used by OutputHelper to sort the Facets for an Output now uses a list to store the ManagedFacets. The correct order is made up by sorting the List using Collections.sort() function of the Java JDK. Therfore, the ManagedFacet class implements the Comparable interface. The return value of its compareTo(other) method depends on the value of the 'position' field.
author Ingo Weinzierl <weinzierl.ingo@googlemail.com>
date Thu, 25 Oct 2012 14:01:46 +0200
parents a91c7e982c32
children 04377ccef10a
line wrap: on
line source
select.gewaesser = SELECT GEWAESSER_NR, NAME FROM SL_GEWAESSER
select.messstelle = SELECT NAME, MESSSTELLE_NR FROM MESSSTELLE WHERE GEWAESSER_NR = :GEWAESSER_NR
select.abflusstafel = SELECT ABFLUSSTAFEL_NR, \
                             ABFLUSSTAFEL_BEZ, \
                             strftime('%s', GUELTIG_VON) * 1000 AS GUELTIG_VON, \
                             strftime('%s', GUELTIG_BIS) * 1000 AS GUELTIG_BIS, \
                             PEGELNULLPUNKT FROM ABFLUSSTAFEL WHERE MESSSTELLE_NR LIKE :number
select.tafelwert = SELECT TAFELWERT_NR AS id, WASSERSTAND AS w, ABFLUSS AS q FROM TAFELWERT \
                          WHERE ABFLUSSTAFEL_NR = :number

http://dive4elements.wald.intevation.org