Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58655
interpreted = N
texte = Thanks Salvatore. I was hoping that my mistake was this simple, but that was a mistype and the search is till ineffective. I'm carrying over a variable named "zipstore" on both sides. The form on the home page reads...
The actual search string is; [showif [action]=search] [search db=admin/stores/ stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore][/ url]&StoreZipCodetype=num] On Jun 28, 2004, at 2:25 AM, Sal D'Anna wrote: > 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/ > ------------------------------------------------------------- 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:
Thanks Salvatore. I was hoping that my mistake was this simple, but that was a mistype and the search is till ineffective. I'm carrying over a variable named "zipstore" on both sides. The form on the home page reads... The actual search string is; [showif [action]=search] [search db=admin/stores/ stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore][/ url]&StoreZipCodetype=num] On Jun 28, 2004, at 2:25 AM, Sal D'Anna wrote: > 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/ > ------------------------------------------------------------- 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:
More on the email templates (1997)
Need correct syntax for writing to header2 (1999)
HELP WITH DATES (1997)
Using [purchase] (1998)
carriage returns in data (1997)
Truncated Sendmail (1998)
Getting Emailer to send mail (1997)
Multiple Ad databases? (1997)
[TaxableTotal] - not working with AOL and IE (1997)
unitshipcost vs shipcosts (1997)
no global [username] or [password] displayed ... (1997)
(no subject) (1997)
Browser Info.txt -- newest additions? (1997)
shipcost (1997)
Orderfile context problem (1998)
textarea inputs and returns (1999)
webmerch and serials - almost there (1997)
Is everybody getting all the posts? (2002)
Help! WebCat2 bug (1997)
Missing from Docs [folderName] (1997)