Mercurial > dive4elements > gnv-client
diff gnv-artifacts/doc/conf/queries.properties @ 428:88cd37c3b5e4
Adjusted sql queries and configuration for verticalcrosssection products. Some code refactoring and improved error handling.
gnv-artifacts/trunk@476 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
|---|---|
| date | Tue, 22 Dec 2009 13:18:07 +0000 |
| parents | 061355435075 |
| children | 363236fc462d |
line wrap: on
line diff
--- a/gnv-artifacts/doc/conf/queries.properties Tue Dec 22 13:10:56 2009 +0000 +++ b/gnv-artifacts/doc/conf/queries.properties Tue Dec 22 13:18:07 2009 +0000 @@ -990,12 +990,11 @@ msv.TIMEVALUE = ? AND \ m.OBJECTID = ? AND \ MEDIAN.MESHPOINT.FEATUREID in \ - ( select FEATUREID \ - from MEDIAN.MESHPOINT mp, \ - MEDIAN.MESH m \ - where m.OBJECTID = ? AND \ - mp.MESHID = m.MESHID AND \ - ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ + ( \ + SELECT distinct FEATUREID \ + FROM MEDIAN.MESHPOINT \ + WHERE ? \ + ) \ order by msv.TIMEVALUE, \ msv.PARAMETERID, \ MEDIAN.MESHPOINT.JPOSITION, \