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

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

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

revision 2236 by torben, Tue Nov 11 13:45:21 2014 UTC revision 2237 by torben, Tue Dec 9 15:49:43 2014 UTC
# Line 109  public class Database { Line 109  public class Database {
109    
110                  String sql = "SELECT postnr " +                  String sql = "SELECT postnr " +
111                                           "FROM fulddaekning.adressetabel " +                                           "FROM fulddaekning.adressetabel " +
                                          //"WHERE distributor = ? and rute is not null " +  
112                                           "WHERE postnr BETWEEN ? AND ? " +                                           "WHERE postnr BETWEEN ? AND ? " +
113                                             "AND rute is null " + // Træk kun liste på postnumre hvor der er ikke-dækkede adresser
114                                           "GROUP BY postnr " +                                           "GROUP BY postnr " +
115                                           "ORDER by postnr";                                           "ORDER by postnr";
116                  PreparedStatement stmt = conn.prepareStatement(sql);                  PreparedStatement stmt = conn.prepareStatement(sql);
Legend:
Removed from v.2236  
changed lines
  Added in v.2237
  ViewVC Help
Powered by ViewVC 1.1.20