2 Replies Latest reply on Oct 4, 2006 7:31 PM by emartek

    Problem with custom tag!!!

      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?