--- android/TrainInfoService/src/dk/thoerup/traininfoservice/db/StationDAO.java	2011/06/08 18:24:24	1511
+++ android/TrainInfoService/src/dk/thoerup/traininfoservice/db/StationDAO.java	2011/06/08 19:11:36	1512
@@ -124,19 +124,19 @@
 	
 	
 	public StationBean getByNameFuzzy(final String name) throws SQLException {
-		String SQL = "SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0, " +
-		"levenshtein(lower(name),lower(?) ) as leven " +
-		"FROM trainstations " + 
-		"WHERE (levenshtein(lower(name),lower(?) ) <= 3) " +
-		"AND  enabled = true " +
-		"ORDER BY leven " + 
-		"LIMIT 1";
+		String SQL = "SELECT * FROM (" +
+					 "    SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address, 0.0, " +
+					 "    levenshtein(lower(name),lower(?) ) as leven " +
+					 "    FROM trainstations " +
+					 "    WHERE  enabled = true ) as lev2 " +
+					 "WHERE (leven <= 3) " +		
+					 "ORDER BY leven " + 
+					 "LIMIT 1";
 
 		class NameSetter implements StatementParamSetter {
 			@Override
 			public void setParams(PreparedStatement stmt) throws SQLException {
 				stmt.setString(1, name );
-				stmt.setString(2, name );
 			}			
 		}