/[projects]/dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java
ViewVC logotype

Diff of /dao/FuldDaekningWorker/src/main/java/dk/daoas/fulddaekning/Database.java

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2707 by torben, Sun Sep 27 13:21:45 2015 UTC revision 2708 by torben, Sun Sep 27 18:20:41 2015 UTC
# Line 100  public class Database { Line 100  public class Database {
100                                  "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " +                                  "LEFT JOIN bogleveringer.postnummerdistributor p on (a.postnr=p.postnr) " +
101                                  "WHERE rute IS NULL " +  //Ingen dækning                                  "WHERE rute IS NULL " +  //Ingen dækning
102                                  //"AND a.postnr BETWEEN ? AND ? " +                                  //"AND a.postnr BETWEEN ? AND ? " +
103                                  //"AND a.postnr BETWEEN 8000 and 8600 " +                                  "AND a.postnr BETWEEN 8000 and 8600 " +
104                                  "AND a.postnr BETWEEN 9000 AND 9300 " +                                  //"AND a.postnr BETWEEN 9000 AND 9300 " +
105                                  "AND latitude IS NOT NULL " +                                  "AND latitude IS NOT NULL " +
106                                  "AND longitude IS NOT NULL " +                                  "AND longitude IS NOT NULL " +
107                                  "AND gadeid IS NOT NULL " +                                  "AND gadeid IS NOT NULL " +
Legend:
Removed from v.2707  
changed lines
  Added in v.2708
  ViewVC Help
Powered by ViewVC 1.1.20