* Made compatible with new Debian autobuilder architecture.

[maemo-mapper] / src / poi.c

diff --git a/src/poi.c b/src/poi.c
index 385d7be7480ba1e17f0aff265a6ce57d7bc99849..10981992876acca3c69073c202aa9ddc07eb0cc4 100644 (file)
--- a/src/poi.c
+++ b/src/poi.c
@@ -228,7 +228,8 @@ poi_db_connect()
                         " where c.enabled = 1"
                         " and p.label like $QUERY or p.desc like $QUERY"
                         " order by (($LAT - p.lat) * ($LAT - p.lat) "
-                                 "+ ($LON - p.lon) * ($LON - p.lon)) DESC",
+                                 "+ ($LON - p.lon) * ($LON - p.lon)) DESC "
+                        " limit 100",
                         -1, &_stmt_browse_poi, NULL);
 
         /* browse poi by category */
@@ -241,7 +242,8 @@ poi_db_connect()
                         " and p.cat_id = $CATID"
                         " and ( p.label like $QUERY or p.desc like $QUERY )"
                         " order by (($LAT - p.lat) * ($LAT - p.lat) "
-                                 "+ ($LON - p.lon) * ($LON - p.lon)) DESC",
+                                 "+ ($LON - p.lon) * ($LON - p.lon)) DESC"
+                        " limit 100",
                         -1, &_stmt_browsecat_poi, NULL);
 
         /* Prepare our SQL statements. */