Re: Zip Code Search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28195
interpreted = N
texte = On 2/28/00 9:27 am, Clint Davis so noted...>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?How about using [format] to ensure a five-character length padded with zeros?&rnZIPdata=[format .5d][variable1][/format]+[format .5d][variable2][/format]Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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)
On 2/28/00 9:27 am, Clint Davis so noted...>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?How about using [format] to ensure a five-character length padded with zeros?&rnZIPdata=[format .5d][variable1][/format]+[format .5d][variable2][/format]Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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 Rob Marquardt

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:

[cart] (1998) 2nd WebCatalog2 Feature Request (1996) WebCat2 - [format thousands] (1997) Banner DNA (1997) Search results templates (1996) Looking for a Manual (1997) Authenticate (1997) Anyone have an invoicing system? (1999) Running 2 two WebCatalog.acgi's (1996) Show if time tags (1997) AAgghh!! Help, please. SSL strikes again. (1997) [shownext max=?] armed (1997) WebCatalog Hosting (1996) AppleScript question (1997) WebCatalog 4.0 has been released! (2000) Three new problems, maybe a fourth (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) RAM variables (1997) Help name our technology! I found it (1997) Where's Cart Created ? (1997)