--- android/DroidRadarService/src/dk/thoerup/droidradarservice/LocationService.java	2009/08/21 12:21:32	273
+++ android/DroidRadarService/src/dk/thoerup/droidradarservice/LocationService.java	2009/08/21 14:03:03	274
@@ -60,7 +60,7 @@
 		final String SQL = "SELECT * FROM ( "+
 						   "               SELECT imei,handle,groupname,latitude,longitude, " +
 						   "                     extract(epoch from now())::int - extract(epoch from updated)::int  AS lastupdate, " + 
-						   "                     earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(56,9))::int AS calcdist " + 
+						   "                     earth_distance( ll_to_earth(latitude,longitude), ll_to_earth(?,?))::int AS calcdist " + 
 						   "               FROM droidradar " +
                            "               WHERE imei <> ? AND updated  > now() - interval '15 minutes'  " +
 						   "       ) AS droidradar2 " +
@@ -93,7 +93,6 @@
 				buff.append("<latitude>").append(res.getString(4) ) .append("</latitude>\n");
 				buff.append("<longitude>").append(res.getString(5) ) .append("</longitude>\n");
 				buff.append("<lastupdate>").append(res.getInt(6) ) .append("</lastupdate>\n");				
-				buff.append("<distance>").append(res.getDouble(7) ) .append("</distance>\n");
 				
 				buff.append("</droid>\n");				
 			}