--- android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java 2010/05/18 15:17:13 732 +++ android/TrainInfoService/src/dk/thoerup/traininfoservice/StationDAO.java 2010/05/18 17:56:43 733 @@ -104,7 +104,7 @@ public List getByLocation(double latitude, double longitude) throws SQLException { String SQL = "SELECT * FROM ( "+ " SELECT id,name,latitude,longitude,stationcode_fjrn,stationcode_stog, stationcode_metro, address," + - " earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + + " earth_distance( earth_coord, ll_to_earth(?,?))::int AS calcdist " + " FROM trainstations " + " WHERE enabled = true " + " ) AS trainstations2 " +