Re: Feedback on CFWebstore?

CFWebstore's new version ROCKS! It includes a full publishing engine, role based security and content protection, the ability to sell memberships to site content, downloadable products and full puchase order/dropshipping capabailites. The value is amazing. I've used CFWebstore for over 5 years and

Feedback on CFWebstore?

Hey David -- CFWebstore's new version ROCKS! It includes a full publishing engine, role based security and content protection, the ability to sell memberships to site content, downloadable products and full puchase order/dropshipping capabailites. The value is amazing -- I really appreciate the fa

Re: How do I perform a radius search based on zip code?

Using a zipcode table with longitude and latitudes, here's a query to get the zipcodes and distances in a given radius of an origin zip code: SELECT ZIP_CODE, (180/Pi() * (ACOS ((SIN(Pi()/180*#OriginLatitude#) * SIN(Pi()/180*Latitude)) + (COS(Pi()/180*#Attributes.OriginLatitude#) * COS(Pi()/180*

Re: How do I perform a radius search based on zip code?

The more accurate query for distances by zip code will not work with Access. Here is an alternative query that will: Given you know the latitude and longitude of the origin zipcode and radius:   SELECT ZIPCODE, SQR(69.1 * (Latitude - #origin.Latitude#) * 69.1 * (Latitude - #origin.Latitude#)

Preventing password sharing on a membership site

I have a client with a paid membership site who recently saw a member post their login information on a public news group. Anybody have a suggestion as to how to stop people from sharing passwords? Is there a practical way to prevent multiple people from logging in with the same username/pas