Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58669
interpreted = N
texte = Thanks Terry. Unforutunately this did not solve the problem. I was excited to try it, but here's my results. 1. This didn't work. Taking at the eq***datarq and the rq just returns all the stores and not the ones that service the specific zip code. Leaving the rq moves me back to square one. Nothing but one return. Our database has 88 stores and instead of bring back records that have 37660 in the zip field, the DNA query just returns all files with this string. [search db=admin/stores/ stores.db&neidNumberdata=[blank]&StoreZipCodedata=[url][zipstore][/ url]] 2. The Type num was correct, no need for that...I think although the real problem has yet to be involved. 3. Thanks for the clarification. 4. Good idea for the max 5 that's better code. Thanks again. I'll keep trying, I just wish this one would go away. David On Jun 28, 2004, at 11:46 AM, Terry Wilson wrote: > I'm coming in a little late on this. No. 1 below is you're problem. > > 1. The eq***datarq looks for an exact match, so you'll never get a > match on db fields containing more than one zip code. Only the fields > containing one zip code and no spaces would be a match. Leave off the > "eq" and just make it ***datarq. Actually, you can leave off the rq if > you like since there aren't any other fielddata parameters in the mix. > > 2. type=num only matters when order or math is important, such as if > you're sorting and you want '2' to come before say, '11' or finding a > range. In your case, you're just looking for a text string; it doesn't > matter if it's letters or numbers. > > 3. Zip codes are assigned alphabetically, not geographically. Well, > yes geographically based on the first 3 digits, but alpha based on the > last 2. There are anomalies because towns may change names over time, > but look at any zipcode database, and you'll immediately see this > pattern. Therefore, a range search would do no good. > > 4. You might put maxlength=5 in your form field for the zip code so > the user doesn't inadvertently get a space in there, or put a zip+4 > entry. No need for the [url] tags here; it's just digits going in. > > Hope this helps. > > Terry > >> Message-Id: <6.1.1.1.2.20040627233732.0309ccb0@mail.garykrockover.com> >> Date: Sun, 27 Jun 2004 23:46:38 -0500 >> From: Gary Krockover
>> Subject: Re: Searching Numbers >> Content-Type: text/plain; charset="us-ascii"; format=flowed >> >> If you're comparing a 5 digit zip code to values in the database that >> arestored as 12345 12345, then you wont get a match since they don't >> (fully)equal one another. I don't think a wo search is going to work >> as one of the"or" words has to match and again, the 5 digit zip isn't >> going to match the5 digit space 5 digit value. Try it, but don't >> think it will work. >> >> You might look at trying: >> close to (numeric only). clZipCodedatarq=92069&clZipCodedata=10 finds >> allrecords whose ZipCode field is within 10 of 92069 (92059 - 92079) >> >> begins with (bw). If the 5 digit code always matches the first 5 >> digitsthat are stored in the db, this would work. If you might match >> on the 2ndset of digits, then this wont work. >> >> The best option, if possible, would be to break those 5 digit splits >> intotwo separate fields. You could then do a range search: > > > ------------------------------------------------------------- > 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 Terry. Unforutunately this did not solve the problem. I was excited to try it, but here's my results. 1. This didn't work. Taking at the eq***datarq and the rq just returns all the stores and not the ones that service the specific zip code. Leaving the rq moves me back to square one. Nothing but one return. Our database has 88 stores and instead of bring back records that have 37660 in the zip field, the DNA query just returns all files with this string. [search db=admin/stores/ stores.db&neidNumberdata=[blank]&StoreZipCodedata=[url][zipstore][/ url]] 2. The Type num was correct, no need for that...I think although the real problem has yet to be involved. 3. Thanks for the clarification. 4. Good idea for the max 5 that's better code. Thanks again. I'll keep trying, I just wish this one would go away. David On Jun 28, 2004, at 11:46 AM, Terry Wilson wrote: > I'm coming in a little late on this. No. 1 below is you're problem. > > 1. The eq***datarq looks for an exact match, so you'll never get a > match on db fields containing more than one zip code. Only the fields > containing one zip code and no spaces would be a match. Leave off the > "eq" and just make it ***datarq. Actually, you can leave off the rq if > you like since there aren't any other fielddata parameters in the mix. > > 2. type=num only matters when order or math is important, such as if > you're sorting and you want '2' to come before say, '11' or finding a > range. In your case, you're just looking for a text string; it doesn't > matter if it's letters or numbers. > > 3. Zip codes are assigned alphabetically, not geographically. Well, > yes geographically based on the first 3 digits, but alpha based on the > last 2. There are anomalies because towns may change names over time, > but look at any zipcode database, and you'll immediately see this > pattern. Therefore, a range search would do no good. > > 4. You might put maxlength=5 in your form field for the zip code so > the user doesn't inadvertently get a space in there, or put a zip+4 > entry. No need for the [url] tags here; it's just digits going in. > > Hope this helps. > > Terry > >> Message-Id: <6.1.1.1.2.20040627233732.0309ccb0@mail.garykrockover.com> >> Date: Sun, 27 Jun 2004 23:46:38 -0500 >> From: Gary Krockover >> Subject: Re: Searching Numbers >> Content-Type: text/plain; charset="us-ascii"; format=flowed >> >> If you're comparing a 5 digit zip code to values in the database that >> arestored as 12345 12345, then you wont get a match since they don't >> (fully)equal one another. I don't think a wo search is going to work >> as one of the"or" words has to match and again, the 5 digit zip isn't >> going to match the5 digit space 5 digit value. Try it, but don't >> think it will work. >> >> You might look at trying: >> close to (numeric only). clZipCodedatarq=92069&clZipCodedata=10 finds >> allrecords whose ZipCode field is within 10 of 92069 (92059 - 92079) >> >> begins with (bw). If the 5 digit code always matches the first 5 >> digitsthat are stored in the db, this would work. If you might match >> on the 2ndset of digits, then this wont work. >> >> The best option, if possible, would be to break those 5 digit splits >> intotwo separate fields. You could then do a range search: > > > ------------------------------------------------------------- > 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:
Request for page test (2003)
Appendfile memory usage (redux) (2003)
carriage returns in data (1997)
WCS Newbie question (1997)
WebCat2: multiple currency support (1997)
Protect (1997)
Ads.db (1997)
WebCatalog2 Feature Feedback (1996)
FCKeditor (2008)
WebDNA Solutions ... sorry! (1997)
using showpage and showcart commands (1996)
WebCat2.0 [format thousands .0f] no go (1997)
missing records (1998)
[WebDNA] New Mountain Lion OSX Server (2013)
Dynamic PDFs? (2002)
Template cache problem with WC4 on Mac OS X (2000)
[addlineitems] (1997)
appleshare/ip (1997)
Generating unique SKU from [cart] - FIXED! (1997)
WCS Newbie question (1997)