RE: A zip code search

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 20872
interpreted = N
texte = This should search your db and match all records that begins with the firstthree characters inputted by your user:[search db=YourDatabase.db&bwYourZipCodeFielddatarq=[getCharsstart=1&end=3][valueFromUser][/getChars]&asYourZipCodeFieldsort=1&YourZipCodeFieldtype=num][foundItems] [YourZipCodeField]
[/foundItems][/search]Aloha, Olin> -----Original Message-----> From: Tim Taylor [mailto:Tim@mail.versa.com]> Sent: Friday, November 06, 1998 10:30 AM> To: WebDNA-Talk@smithmicro.com> Subject: A zip code search>>> Hi all>> 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?>> Thanks>> Tim Taylor> Webmaster> http://www.growzone.com> Tim@versa.com> t h e s i t e f o r t h e> g r e e n i n d u s t r y> 1.888.800.5904>>>> Associated Messages, from the most recent to the oldest:

RE: A zip code search (Olin Lagon 1998) Re: A zip code search (PCS Technical Support 1998)

This should search your db and match all records that begins with the firstthree characters inputted by your user:[search db=YourDatabase.db&bwYourZipCodeFielddatarq=[getCharsstart=1&end=3][valueFromUser][/getChars]&asYourZipCodeFieldsort=1&YourZipCodeFieldtype=num][founditems] [YourZipCodeField]
[/foundItems][/search]Aloha, Olin> -----Original Message-----> From: Tim Taylor [mailto:Tim@mail.versa.com]> Sent: Friday, November 06, 1998 10:30 AM> To: WebDNA-Talk@smithmicro.com> Subject: A zip code search>>> Hi all>> 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?>> Thanks>> Tim Taylor> Webmaster> http://www.growzone.com> Tim@versa.com> t h e s i t e f o r t h e> g r e e n i n d u s t r y> 1.888.800.5904>>>> Olin Lagon

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:

spawn (1998) upload pictures any solution (1999) Triggers (2003) WebMerchant Config problems (2000) [WebDNA] listfiles on linux server (2011) Formulas.db / Quantity Discount problem (1998) Error Log.db --however (1997) Forms Search Questions (1997) E 5 Mac Authentication trouble (2000) Cookies and webcat (1997) WebDNA and ASP on Same Server (2004) DataBaseHelper Flawed (1997) Webten + Webcat running smooth (1998) 5.0 Preview Promotion Extension (2003) getmimeheader host on my local machine (2003) Navigator 4.01 (1997) [WebDNA] [BULK] users.db password lost (2011) [WebDNA] Need someone to port CakePHP auction site to WebDNA (2010) Sort Order on a page search (1997) [table] question (2007)