Re: Zip Code Search
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28192
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:
A question on sub-categories (1997)
Date subtraction (2002)
WC2.0 Memory Requirements (1997)
Email encryption (1998)
[lineitems] Loop Break (2004)
Page Counters? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Moment of Thanks (1997)
Template not completely processed (1998)
[raw] & typhoon pro 3.0 or 4.0 (2001)
carriage returns in data (1997)
Keep away (1997)
webcat2b12 CGI -- Date comparisons (1997)
more trouble with [showif] in [search] = busted [shownext] (2000)
showif (1999)
RE: Multiple Stores and WebCatalog Prefs (1997)
Modifying Carts (1999)
Proper file locations (1997)
webcat 3.06f on Linux keeps dying (1999)
Help name our technology! I found it (1997)