Re: A zip code search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20871
interpreted = N
texte = >I'm trying to use webcatalog to do a simple dealer locater for a >Manufacturer's site. I have all the dealers listed in a data base with >full 9 digit zip codes. I want the user to type in there own zip code and >have it return the closest dealers. I figure if a user types in 78704 >webcatalog could return all the zipcodes that start with 787 and effectivly >ignore the rest. Does anyone know a search paramiter that will make this >happen?Yes, the 'begins with' comparison, as in bwZipCodeData=787. You can use [GetChars] to just chop off the first 3 characters of whatever the user types in.Also, you can try the 'close' search comparison, which finds values that are 'close to' a particular number (and it may even work for text, too, in the case of 9-digit zips). Look at the online docs under Searching for more information (or in the index of the PDF manual for bw and cl).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I'm trying to use webcatalog to do a simple dealer locater for a >Manufacturer's site. I have all the dealers listed in a data base with >full 9 digit zip codes. I want the user to type in there own zip code and >have it return the closest dealers. I figure if a user types in 78704 >webcatalog could return all the zipcodes that start with 787 and effectivly >ignore the rest. Does anyone know a search paramiter that will make this >happen?Yes, the 'begins with' comparison, as in bwZipCodeData=787. You can use
[getchars] to just chop off the first 3 characters of whatever the user types in.Also, you can try the 'close' search comparison, which finds values that are 'close to' a particular number (and it may even work for text, too, in the case of 9-digit zips). Look at the online docs under Searching for more information (or in the index of the PDF manual for bw and cl).Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical 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:
Search Context: How to set Max=N? (2000)
WebDNA 5 & iTools 7 (2003)
Archives (2001)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
[WebDNA] WebDNA frameworks and beginners (2012)
about this server and links to who (1997)
Tabled Discount (2003)
WebCat2b13 Command Reference Doc error (1997)
Unexpected error (1997)
tcp connect includes (1999)
truncating email part II (1997)
RE: Credit card processing - UK (1997)
Help! WebCat2 bug (1997)
MATH PROBLEM (1997)
using showpage and showcart commands (1996)
Format of Required fields error message (1997)
Prices coming up 0.00 (2001)
[WebDNA] v7 help (2012)
Answer: WebDelivery downloads alias, not original ? (1997)
duplicate cart numbers (2002)