OK. But where do you get the information from the database when you are selecting? It would appear to me that you need to use the zip code information in the records, pass those through the great circle calculation, then order the output based on the distance between the two points.
Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Phill B [mailto:[EMAIL PROTECTED] Sent: Friday, January 28, 2005 2:44 PM To: SQL Subject: Re: zip code search problems I run a query right before this one that will verify the form passed zip code and get the lat and long. On Fri, 28 Jan 2005 14:21:12 -0500, Ray Thompson <[EMAIL PROTECTED]> wrote: > I do not see in your SQL where you are using the ZIP code in the database as > part of the query. It would seem that you want to limit by the passed zip > codes (in the where clause) and use the ZIP code in the database in the > calculations rather than the passed zip codes. > > Ray Thompson > Tau Beta Pi (www.tbp.org) > The Engineering Honor Society > 865-546-4578 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:6:2100 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/6 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
