Mercurial > dive4elements > gnv-client
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 427:a95aaeb206f7 | 428:88cd37c3b5e4 |
|---|---|
| 988 m.PARTIDMAX >= msv.PARTID AND \ | 988 m.PARTIDMAX >= msv.PARTID AND \ |
| 989 msv.PARAMETERID = ? AND \ | 989 msv.PARAMETERID = ? AND \ |
| 990 msv.TIMEVALUE = ? AND \ | 990 msv.TIMEVALUE = ? AND \ |
| 991 m.OBJECTID = ? AND \ | 991 m.OBJECTID = ? AND \ |
| 992 MEDIAN.MESHPOINT.FEATUREID in \ | 992 MEDIAN.MESHPOINT.FEATUREID in \ |
| 993 ( select FEATUREID \ | 993 ( \ |
| 994 from MEDIAN.MESHPOINT mp, \ | 994 SELECT distinct FEATUREID \ |
| 995 MEDIAN.MESH m \ | 995 FROM MEDIAN.MESHPOINT \ |
| 996 where m.OBJECTID = ? AND \ | 996 WHERE ? \ |
| 997 mp.MESHID = m.MESHID AND \ | 997 ) \ |
| 998 ? = (select ? from MEDIAN.MESHPOINT where FEATUREID = ?)) \ | |
| 999 order by msv.TIMEVALUE, \ | 998 order by msv.TIMEVALUE, \ |
| 1000 msv.PARAMETERID, \ | 999 msv.PARAMETERID, \ |
| 1001 MEDIAN.MESHPOINT.JPOSITION, \ | 1000 MEDIAN.MESHPOINT.JPOSITION, \ |
| 1002 MEDIAN.MESHPOINT.IPOSITION, \ | 1001 MEDIAN.MESHPOINT.IPOSITION, \ |
| 1003 MEDIAN.MESHPOINT.KPOSITION | 1002 MEDIAN.MESHPOINT.KPOSITION |