Re: Zip Code Search
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28189
interpreted = N
texte = An off the cuff suggestion (meaning it may well not work) - since the problem is consistent, you can count the number of characters, and whenever their are only 4 characters, throw a 0 in front.>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.9999 > >cdavis@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 ------------------------------------------------------------- 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:
An off the cuff suggestion (meaning it may well not work) - since the problem is consistent, you can count the number of characters, and whenever their are only 4 characters, throw a 0 in front.>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.9999 > >cdavis@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 ------------------------------------------------------------- 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
Stephen Reiss
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:
[OT] Mozilla | Was: R.I.P. Netscape (2003)
Re:Authenticate (1998)
Browser Problem?!? Still getting Error message using (1997)
New commands in Final candidate (1997)
Mac Programs (1998)
Why is [authenticate] not recognizing [username] on all sitedirectories? (2000)
WebCatalog can't find database (1997)
Date and Time Math (1997)
Bug? (1997)
Creating 404 Not Found pages (1999)
URGENT: NO BUG, woFIELDdata & FIELDword=ww (2002)
Virtual hosting and webcatNT (1997)
Re[2]: Unix Webcat Permission - Suggestions (2000)
shipcost (1997)
[input]?? (1998)
Configuring E-mail (1997)
cybercash (1998)
MySQL (2003)
WebCatalog Upgrade Pricing? (1997)
[COMMITDATABASE FileName] (2000)