Re: Zip Code Search
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28191
interpreted = N
texte = You can wrap the in coming zip code in a math context. Check to see if has less than 5 digits, then use the text variable to put the leading zero back after adding and subtracting 100. [text]_ZIPdata=08504[/text] [showif [countchars][math show=f][_ZIPdata][/math][/countchars]<5][math show=f]zip_temp1=[_ZIPdata]-100[/math][math show=f]zip_temp2=[_ZIPdata]+100[/math] [text]variable1=0[zip_temp1][/text] [text]variable2=0[zip_temp2][/text][/showif][variable1]
[_ZIPdata]
[variable2]
Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Clint Davis Sent: Monday, February 28, 2000 7:28 AM To: WebCatalog Talk Subject: Zip Code Search 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 ------------------------------------------------------------- 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:
You can wrap the in coming zip code in a math context. Check to see if has less than 5 digits, then use the text variable to put the leading zero back after adding and subtracting 100. [text]_ZIPdata=08504[/text] [showif [countchars][math show=f][_ZIPdata][/math][/countchars]<5][math show=f]zip_temp1=[_ZIPdata]-100[/math][math show=f]zip_temp2=[_ZIPdata]+100[/math] [text]variable1=0[zip_temp1][/text] [text]variable2=0[zip_temp2][/text][/showif][variable1]
[_ZIPdata]
[variable2]
Technical Support ********************************** Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) 16855 West Bernardo Drive, #380 | ------------------------- San Diego, CA 92127 | Software & Site Development WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 ********************************* -----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Clint Davis Sent: Monday, February 28, 2000 7:28 AM To: WebCatalog Talk Subject: Zip Code Search 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 ------------------------------------------------------------- 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
WebDNA Support
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:
$flushcache causes crash (2000)
SiteGuard Admin Feature ? (1997)
Major Security Hole IIS NT (1998)
EIMS Problems (1997)
logic help (1998)
Resume Catalog ? (1997)
multi-paragraph fields (1997)
can you take a look (2003)
Is Web Merchant Necessary? (2000)
Help formatting search results w/ table (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
Price recalc based on quantity (1997)
Sendmail & Time Issue (2001)
Redirect (2000)
Finding max value for a field (1997)
form data submission gets truncated (1997)
Up and running ... at last !! (1997)
Bug? (1997)
[ELSEIF] was hideif [x]=1,2,3..: (2003)
Webstar 1.3.1 PPC (1997)