I think he wrote it for Access because in MS Sql it needs to now where to round up. I think it needs to be closer to 4 but at this point I'm not to sure.
Phillip B. www.LoungeRoyale.com www.FillWorks.com ----- Original Message ----- From: "Scott Weikert" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Monday, August 25, 2003 3:20 PM Subject: Re: zipcode search problem > >SELECT zip, lat, long, state, city, > >ROUND((ACOS((SIN(#passedzip.lat#/57.2958) * SIN(lat/57.2958)) + > >(COS(#passedzip.lat#/57.2958) * COS(lat/57.2958) * > >COS(long/57.2958 - #passedzip.long#/57.2958)))) > >* 3963, 1) AS distance > > I think I see it this time. :) > > You've got an extra ", 1" inside the bit definining 'distance', right at > the end. It's not in the query listed on the page you linked. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
