Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58645
interpreted = N
texte = The 5 digits with 5 more digits may be throwing it off, but you do also need to add &StoreZipCodetype=num in the search. GK At 09:59 PM 6/27/2004, you wrote: >Perhaps there is a simple solution here that I'm overlooking. > >We have a database that includes a variety of zip codes so users can >come to the home page, enter a zip code and return all our stores that >service a particular area. A user that enters 37663 may find 5 or 6 >stores that service them. > >The field name is StoreZipCode and records are entered as such - A five >character number with a space and then another five character number: > >37663 37664 37665 37667 > >We would like for the user to go to the home page form. Form carries a >value called "zipstores" to a DNA page with the following search >string. > >[search >db=admin/stores/ >stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]] > >The [founditems] loop seems funny because it seems to bring back a few >numbers, but it does not seem to be working through the data field and >instead only shows matches where [zipstore] is the first record in the >set. > >Is my search string incorrect to find numbers like this? > >Thanks. > >David ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
The 5 digits with 5 more digits may be throwing it off, but you do also need to add &StoreZipCodetype=num in the search. GK At 09:59 PM 6/27/2004, you wrote: >Perhaps there is a simple solution here that I'm overlooking. > >We have a database that includes a variety of zip codes so users can >come to the home page, enter a zip code and return all our stores that >service a particular area. A user that enters 37663 may find 5 or 6 >stores that service them. > >The field name is StoreZipCode and records are entered as such - A five >character number with a space and then another five character number: > >37663 37664 37665 37667 > >We would like for the user to go to the home page form. Form carries a >value called "zipstores" to a DNA page with the following search >string. > >[search >db=admin/stores/ >stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]] > >The [founditems] loop seems funny because it seems to bring back a few >numbers, but it does not seem to be working through the data field and >instead only shows matches where [zipstore] is the first record in the >set. > >Is my search string incorrect to find numbers like this? > >Thanks. > >David ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
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:
WebCatalog stalls (1998)
WebMerchant Problem (1999)
Sorting Numbers (1997)
Parameter Problem ATTN: Ken Grome (1998)
WC2.0 Memory Requirements (1997)
WC TableGrinder (1997)
Wanted: Broader string manipulation functions (1997)
Handy Browser Counter Tip (1997)
Great product and great job ! (1997)
[WebDNA] Function "libraries" (2009)
[WebDNA] v7 with SSL (2012)
Multi-processor Mac info ... (1997)
Fwd: Problems with Webcatalog Plug-in (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
[Sum] function? (1997)
Nesting format tags (1997)
[math] are you there? (1999)
details (2003)
cookies and [returnraw] (1997)
HELP WITH DATES (1997)