Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58646
interpreted = N
texte = Boy. I thought that was going to solve the problem and forget to clarify data types too often, but I tried to update the file and still come up with the same problem. [search db=admin/stores/ stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZi pCodetype=num] Still the same problem though. Any other suggestions? Thanks. David On Jun 27, 2004, at 11:08 PM, Gary Krockover wrote: > 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/ > ------------------------------------------------------------- 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:
Boy. I thought that was going to solve the problem and forget to clarify data types too often, but I tried to update the file and still come up with the same problem. [search db=admin/stores/ stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZi pCodetype=num] Still the same problem though. Any other suggestions? Thanks. David On Jun 27, 2004, at 11:08 PM, Gary Krockover wrote: > 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/ > ------------------------------------------------------------- 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/
David Cate
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:
Alcatraz must have been nicer than this... (2000)
WebCat b15 Mac plug-in (1997)
problems with 2 tags (1997)
Another question (1997)
Separate SSL Server (1997)
WebCatalog Hosting (1996)
Multiple Pulldowns (1997)
[WebDNA] testing (2014)
Bulk Email Limits (2001)
WebCatalog 2.1 for NT (1998)
Bill To - Ship To Information display (1997)
OT: Unix question (2003)
WebCat2 - [format thousands] (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Disappearing HTML/WebDNA (1998)
ReturnRaw context (1997)
normal users.db calls ... (1998)
Location of Browser Info.txt file (1997)
NT considerations (1997)
Location of Webcat site in folder hierarchy (1997)