I am using this custom tag (code attached) to search my
database and return dealers that are within a user specifed range
and a user specified zip code. It does this perfectly but only if
the zipcode is already in the database. If a user enters a zip code
that is not in the database then it returns 'no records found' even
if other zip codes fall within the specified radius.
I am thinking that I have to somehow incorporate all zip
codes within my database in order to get accurate results. If I
enter a lone zip code with only latitude and longitude data into
the database and then run a search on that zip I get all the
dealers within my specified range, however I also get that lone
entry in my results too...with no dealer name, etc. Anyone have any
ideas on how to get around this or to make 'blank' zips not appear
in the results?