Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58644
interpreted = N
texte = 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:
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/
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:
form crasehes server (1997)
Nitro plugin? (1998)
Announcing general availabilty of WebDNA 4.5 release (2002)
Emailer help....! (1997)
RE: Missing contexts on NT (1997)
no global [username] or [password] displayed ... (1997)
Encrypting WebDNA Templates and eligible files (1999)
Newbie Tax Question (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Line Feed Character Appended (1998)
Lost Records in Database (2001)
WCS Newbie question (1997)
OT: Web Cams (2003)
PCS Frames (1997)
Email address checker (2002)
Sorting error (1997)
Re:HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
GuestBook example (1997)
# fields limited? (1997)
b12 cannot limit records returned and more. (1997)