[web2py] Executesql Not returning results

[Andrew Evans]

I am trying to figure out why executesql is not returning any results in
this query.  I am using mysql, any suggestions would be greatly
appreciated. There are no errors just an empty view

*cheers

Code Below

*Controller*

def location():
    current_lat = request.post_vars["lat"]
    current_lon = request.post_vars["lon"]
    val = request.post_vars["search-distance"]
    distance = db.executesql("SELECT *, (3959 * acos(cos(radians(%f)) *
cos(radians(latitude)) * cos(radians(longitude) - radians(%f)) +
sin(radians(%f)) * sin(radians(latitude)))) AS distance FROM listing HAVING
distance < %d ORDER BY distance LIMIT 0, 20;" % (float(current_lat),
float(current_lon), float(current_lat), int(val)))
    return dict(distance=distance)


*Example View*

{{for query in distance:}}
    <div class="listingItem">
        <h2>{{=query[2]}}</h2>
        <p>
        {{=query[3]}}

--