--- android/TrainInfoService/src/dk/thoerup/traininfoservice/LocateStations.java 2009/10/01 05:24:35 376 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/LocateStations.java 2009/10/01 08:21:09 377 @@ -59,7 +59,7 @@ " SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, " + " earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + " FROM trainstations " + - " WHERE latitude IS NOT NULL AND longitude IS NOT NULL " + + " WHERE enabled = true AND latitude IS NOT NULL AND longitude IS NOT NULL " + " ) AS trainstations2 " + "ORDER BY calcdist ASC " + "LIMIT 4 ";