Mercurial > dive4elements > river
annotate etl/src/main/resources/sql/aft-oracle-jdbc-oracledriver.properties @ 6399:10fe6758dfb0
Datacage: Introduced <dc:container-context>.
It is an analogon to <dc:context> to fetch the data from a collection.
Usage:
<dc:container-context container="myContainer">
<dc:properties>
<dc:property name="a"/>
<dc:property name="b" alias="c"/>
</dc:properties>
<dc:for-each><!-- as usual --></dc:for-each>
</dc:container-context>
Iterates over the collection stored on stack with the name 'myContainer'
and fetched for each item via getA() and getB() the values to be stored
under 'a' and 'c'. dc:has-result() & Co work as expected.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Fri, 21 Jun 2013 20:02:15 +0200 |
parents | 5aa05a7a34b7 |
children |
rev | line source |
---|---|
4775
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
1 select.abflusstafel = \ |
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
2 SELECT ABFLUSSTAFEL_NR, \ |
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
3 ABFLUSSTAFEL_BEZ, \ |
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
4 GUELTIG_VON, \ |
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
5 GUELTIG_BIS, \ |
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
6 PEGELNULLPUNKT, \ |
5480
7a68967ca72a
AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4775
diff
changeset
|
7 AT.BFG_ID \ |
7a68967ca72a
AFT/DIPS: Small fixes and workarounds for Oracle DB problems.
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4775
diff
changeset
|
8 FROM ABFLUSSTAFEL AT \ |
4775
d9f1202cef78
Do the pairing of FLYS and AFT discharge tables by the field 'ABFLUSSTAFEL.BFG_ID' in
Sascha L. Teichmann <teichmann@intevation.de>
parents:
4106
diff
changeset
|
9 WHERE MESSSTELLE_NR LIKE :number |