--- dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseLayerImplementation.java	2016/01/26 08:28:37	2846
+++ dao/DaoAdresseVedligehold/src/main/java/dk/daoas/adressevedligehold/db/DatabaseLayerImplementation.java	2016/01/26 11:48:37	2847
@@ -20,19 +20,19 @@
 
 public class DatabaseLayerImplementation  {
 	
-	static boolean DEBUG = false;
+	//static boolean DEBUG = false;
 	
 	
 	public List<Address> getAllAdresses() throws SQLException {
 		TimingHelper timing = new TimingHelper();
 		
-		String debugFilter = DatabaseLayerImplementation.DEBUG ? " WHERE postnr >= 6000 " : "";
+		//String debugFilter = DatabaseLayerImplementation.DEBUG ? " WHERE postnr >= 6000 " : "";
 		
 		String sql = 
 				"SELECT id,vejnavn,husnr,husnrbogstav,kommunekode,vejkode,postnr,gadeid,upper(distributor) AS distributor,dbkbane,latitude,longitude, "
 				+ "rutema,korelistema,ruteti,korelisteti,ruteon,korelisteon,ruteto,korelisteto,rutefr,korelistefr,rutelo,korelistelo,ruteso,korelisteso "
 				+ "FROM fulddaekning.adressetabel "
-				+ debugFilter
+				//+ debugFilter
 				;
 		
 		try ( Connection conn = DBConnection.getConnection();		
@@ -114,7 +114,8 @@
 					"RuteFr=?, KorelisteFr=?, " +
 					"RuteLo=?, KorelisteLo=?, " +
 					"RuteSo=?, KorelisteSo=?, " +
-				    "Distributor=? " +
+				    "Distributor=?, " +
+				    "DBKBane=? " +
 					"WHERE id=?";
 					
 					
@@ -140,7 +141,8 @@
 					stmt.setString(14, addr.korelisteSondag);
 
 					stmt.setString(15, addr.distributor);
-					stmt.setInt(16, addr.id);
+					stmt.setInt(16, addr.dbkBane);
+					stmt.setInt(17, addr.id);
 
 					
 					stmt.execute();