Aight, I know some o use guyz are math wizzes and I ain't. I am persistent though, and I will gladly use stolen/purloined/borrowed/copied/etc code.
I have a table of warrants 55,000+ which I have geocoded. I am testing a system that will push out information, via email, to the neighborhood watch groups, a table of crimes within a 1/2 mile radius, over the past 30 days. That data is already available via a system the MPD has and I'm pushing it to some test users. I want to also add into those emails a listing of warrants within that radius and push it out as well. Therein lies the problem. (I'm afraid I must have been distracted when those classes were taught). Does anyone have a clue how to do a select from a table given a lat and long and select all records that fall within the 1/2 mile radius? Help!!!!!! John Harvey _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]@shelbynet.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
