Select Code to Download

y $lon = -0.232323127347249;
...
$sth = $sp->dbh->prepare($sql);
$sth->execute($lon);
print STDERR "Rows using placeholders ".$sth->rows."\n";

Rows not using placeholders 5488
Rows using placeholders 12888

__DATA__
insert into lat_long (location_id, lat, lon) values(44977, 48.3547, 11
+.7875);
...
insert into lat_long (location_id, lat, lon) values(71776, 48.1435, 11
+.5574);
insert into lat_long (location_id, lat, lon) values(65883, 48.1269, 11
+.6363);
insert into lat_long (location_id, lat, lon) values(65884, 48.1515, 11
+.6178);