Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58650
interpreted = N
texte = Maybe this is just a mistype but you say you are carrying over a form value of [zipstores] but your search string says [zipstore]. I always found this useful when rechecking a form value using localhost. [showif [ipaddress]=127.000.000.001] The following are all the form variables available to this page:
[FormVariables] [index],[name],[value]
[/FormVariables] [/showif] Salvatore D'Anna DotNetNuke Hosting -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of David Cate Sent: Sunday, June 27, 2004 7:59 PM To: WebDNA Talk Subject: Searching Numbers 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/ __________ NOD32 1.796 (20040626) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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:
Maybe this is just a mistype but you say you are carrying over a form value of [zipstores] but your search string says [zipstore]. I always found this useful when rechecking a form value using localhost. [showif [ipaddress]=127.000.000.001] The following are all the form variables available to this page:
[formvariables] [index],[name],[value]
[/FormVariables] [/showif] Salvatore D'Anna DotNetNuke Hosting -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of David Cate Sent: Sunday, June 27, 2004 7:59 PM To: WebDNA Talk Subject: Searching Numbers 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/ __________ NOD32 1.796 (20040626) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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/
"Sal D'Anna"
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:
Setting up the server (1997)
contextual shownext (1998)
WebCat2 - [include] tags (1997)
More Hide IFs (2000)
Formvariable won't update (1999)
syntax question, not in online refernce (1997)
form data submission gets truncated (1997)
cart file creation (2003)
[WriteFile] problems (1997)
How to combine two or more audio format files listed in a WebCat (1999)
Re[2]: Next X hits (1996)
Navigator 4.01 (1997)
Getting total number of items ordered (1997)
Is there a way......... (2000)
Another question (1997)
[SearchString] problem with [search] context (1997)
WebCatalog 4.0.2rc1 and rc2 crash WebSTAR on quit (2001)
Strange errors in error log (1998)
Online reference (1997)
Limiting user access to .tmpl files (1997)