>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:> Get the mailserver that powers this list at http://www.coolfusion.com
