7 Replies Latest reply on Feb 27, 2014 11:53 AM by BKBK

    Loop through result set and delete row

    tjbee

      so here is what I need -

       

      I have a query that pulls rows from the Database through a stored procedure.(these are properties in an area)

       

      Before I start looping through the query, I need to check the distance between my current location and the property. If it less than 5 miles, only then should I display that property. The distance in miles will be chosen while submitting the search form.

       

      So is there a way to delete rows from the result set based on the criteria? Or

      Is there a better way to accomplish this? I am using the the google api to get the latitudes and longitudes. The other issue to keep in mind is the load time.

       

      Thanks