Zip Code Search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28173
interpreted = N
texte = I have set up a zip code search using the following code:[math show=F]variable1=[_ZIPdata]-100[/math][math show=F]variable2=[_ZIPdata]+100[/math][/showif] [search db=adv_dealers.db&rnZIPdata=[variable1]+[variable2]&_namesort=1&_names dir=as&[formvariables name= _&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables]startat=[ startat]]This works perfectly for all zip codes except those starting with a zero. The [math] context drops the leading zero and the search returns inaccurate results. Example:Zip=08085 (New Jersey) returns results for 8085* (Colorado)Any ideas on reestablishing the leading zero?Thanks, Clint Davis Gray Loon Marketing Group 812.422.9999cdavis@grayloon.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: newbie question about zip code search (Brian Boegershausen 2003)
  2. Re: newbie question about zip code search (Clint Davis 2003)
  3. Re: newbie question about zip code search (Brian Boegershausen 2003)
  4. Re: newbie question about zip code search (Christer Olsson 2003)
  5. Re: newbie question about zip code search (Clint Davis 2003)
  6. Re: newbie question about zip code search (steve chun 2003)
  7. Re: newbie question about zip code search (Brian Boegershausen 2003)
  8. Re: newbie question about zip code search (Clint Davis 2003)
  9. Re: newbie question about zip code search (Kimberly D. Walls 2003)
  10. Re: newbie question about zip code search (Brian Boegershausen 2003)
  11. Re: newbie question about zip code search (Clint Davis 2003)
  12. Re: newbie question about zip code search (steve chun 2003)
  13. Re: newbie question about zip code search (Glenn Busbin 2003)
  14. Re: newbie question about zip code search (Tim Robinson 2003)
  15. Re: newbie question about zip code search (Tim Robinson 2003)
  16. newbie question about zip code search (steve chun 2003)
  17. Re: Zip Code Search (Rob Marquardt 2000)
  18. Re: Zip Code Search (Rob Marquardt 2000)
  19. Re: Zip Code Search (Chuck Rice 2000)
  20. Re: Zip Code Search (Chuck Rice 2000)
  21. Re: Zip Code Search (WebDNA Support 2000)
  22. Re: Zip Code Search (WebDNA Support 2000)
  23. Re: Zip Code Search (Stephen Reiss 2000)
  24. Re: Zip Code Search (Stephen Reiss 2000)
  25. Zip Code Search (Clint Davis 2000)
  26. Zip Code Search (Clint Davis 2000)
  27. RE: A zip code search (Olin Lagon 1998)
  28. Re: A zip code search (PCS Technical Support 1998)
  29. A zip code search (Tim Taylor 1998)
I have set up a zip code search using the following code:[math show=F]variable1=[_ZIPdata]-100[/math][math show=F]variable2=[_ZIPdata]+100[/math][/showif] [search db=adv_dealers.db&rnZIPdata=[variable1]+[variable2]&_namesort=1&_names dir=as&[formvariables name= _&exact=F][getchars start=2][name][/getchars]=[url][value][/url]&[/formvariables]startat=[ startat]]This works perfectly for all zip codes except those starting with a zero. The [math] context drops the leading zero and the search returns inaccurate results. Example:Zip=08085 (New Jersey) returns results for 8085* (Colorado)Any ideas on reestablishing the leading zero?Thanks, Clint Davis Gray Loon Marketing Group 812.422.9999cdavis@grayloon.com------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Clint Davis

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Looking for a host (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) Displaying photo attached to first record (1997) Almost a there but..bye bye NetCloak (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) Problems with sql: "not supported" (2005) WebCat2 several catalogs? (1997) Re:quit command on NT (1997) [WebDNA] is this expected behavior for [arrayget]? (2009) [WebDNA] XML Help please (2009) Error Lob.db records error message not name (1997) Showif? (2000) WebCatalog2 Feature Feedback (1996) Credit Card Number checking (1997) Forum - Test Request (2005) Re:Merging databases (1997) FTP Address (2003) Clean Code: Rules for inserting keyboard returns? (1997) [ShowCart]-- was ThankYou page problems (1997) Re:UPS, FEDEX TRACKING (1999)