Re: Searching Numbers
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58667
interpreted = N
texte = With multiple space-delimited zip codes in one field, you can't type it as NUM or do an EQ match and expect it to find a single zip code within the field. CL an RN won't work either. You need to use a WA (word all) match, and specify the WORD as WW (whole word)... [search db=admin/stores/ stores.db&neidNumberdata=[blank]&waStoreZipCodeDatara=[url][zipstore][/ url]&StoreZipCodeword=WW] - brian On Jun 28, 2004, at 7:01 AM, David Cate wrote: > Gary, > > Thanks and these are good suggestions. Let me understand this a little > more. > > The 5 digit zip codes in our database will are all different, your > example had two matching numbers. That may be irrelevant, but just > wanted to make sure. I was thinking that if a store had let's say 5 > different zip codes, > Store A - 37660 37645 37662 37660 37665 and another store had > Store B - 37668 37612 37601 37605 37665 and a search query [zipstores] > came across to search the StoreZipCode database as 37665 that the DNA > search query would return both Store A and Store B. > > That is not the case as a matter of fact, this search string is real > hinky. I have noticed that some search queries let's say 24251 will > not even return a Store that has that value (24251) in the > StoreZipCode database. Augh!! > > That 'close to' reference in DNA is one that I've never seen and might > be a good idea as a last resort. This hilly area of East Tennessee has > some fragmented zip codes and this is not the best solution as the > mountains break up Zip codes into a structure that makes it difficult > to use a range. > > I'm not sure I understand the range search that you describe and will > consider that a little more today as I continue to research a > solution. > > Thanks for the thoughts though. Always appreciated!! > > David > > On Jun 28, 2004, at 12:46 AM, Gary Krockover wrote: > >> If you're comparing a 5 digit zip code to values in the database that >> are stored 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 the 5 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 >> all records whose ZipCode field is within 10 of 92069 (92059 - 92079) >> >> begins with (bw). If the 5 digit code always matches the first 5 >> digits that are stored in the db, this would work. If you might >> match on the 2nd set of digits, then this wont work. >> >> The best option, if possible, would be to break those 5 digit splits >> into two separate fields. You could then do a range search: >> >> rnStoreZipCodedatarq=[lowzip] [highzip]&StoreZipCodedatatype=num >> >> It would be pretty easy to write some WebDNA that would split those >> up for you in one swoop while writing to another database that you >> could then swap out for the one you have now. Look into using >> [listwords] to handle that for you. >> >> GK >> >> >> At 11:30 PM 6/27/2004, you wrote: >>> Thanks Gary, the spaces are email related. >>> >>> I tried the [url] tags around the search, but still come up with the >>> same problems. The 5 digit zip code doesn't seem to find the records. >>> We have entered the zip codes into one field thinking that the values >>> would behave as words. >>> >>> [search >>> db=admin/stores/ >>> stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore] >>> [/ url]&StoreZipCodetype=num] >>> >>> Should I consider a wo search like a keyword search instead of a data >>> lookup? >>> >>> David >>> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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:
With multiple space-delimited zip codes in one field, you can't type it as NUM or do an EQ match and expect it to find a single zip code within the field. CL an RN won't work either. You need to use a WA (word all) match, and specify the WORD as WW (whole word)... [search db=admin/stores/ stores.db&neidNumberdata=[blank]&waStoreZipCodeDatara=[url][zipstore][/ url]&StoreZipCodeword=WW] - brian On Jun 28, 2004, at 7:01 AM, David Cate wrote: > Gary, > > Thanks and these are good suggestions. Let me understand this a little > more. > > The 5 digit zip codes in our database will are all different, your > example had two matching numbers. That may be irrelevant, but just > wanted to make sure. I was thinking that if a store had let's say 5 > different zip codes, > Store A - 37660 37645 37662 37660 37665 and another store had > Store B - 37668 37612 37601 37605 37665 and a search query [zipstores] > came across to search the StoreZipCode database as 37665 that the DNA > search query would return both Store A and Store B. > > That is not the case as a matter of fact, this search string is real > hinky. I have noticed that some search queries let's say 24251 will > not even return a Store that has that value (24251) in the > StoreZipCode database. Augh!! > > That 'close to' reference in DNA is one that I've never seen and might > be a good idea as a last resort. This hilly area of East Tennessee has > some fragmented zip codes and this is not the best solution as the > mountains break up Zip codes into a structure that makes it difficult > to use a range. > > I'm not sure I understand the range search that you describe and will > consider that a little more today as I continue to research a > solution. > > Thanks for the thoughts though. Always appreciated!! > > David > > On Jun 28, 2004, at 12:46 AM, Gary Krockover wrote: > >> If you're comparing a 5 digit zip code to values in the database that >> are stored 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 the 5 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 >> all records whose ZipCode field is within 10 of 92069 (92059 - 92079) >> >> begins with (bw). If the 5 digit code always matches the first 5 >> digits that are stored in the db, this would work. If you might >> match on the 2nd set of digits, then this wont work. >> >> The best option, if possible, would be to break those 5 digit splits >> into two separate fields. You could then do a range search: >> >> rnStoreZipCodedatarq=[lowzip] [highzip]&StoreZipCodedatatype=num >> >> It would be pretty easy to write some WebDNA that would split those >> up for you in one swoop while writing to another database that you >> could then swap out for the one you have now. Look into using >> [listwords] to handle that for you. >> >> GK >> >> >> At 11:30 PM 6/27/2004, you wrote: >>> Thanks Gary, the spaces are email related. >>> >>> I tried the [url] tags around the search, but still come up with the >>> same problems. The 5 digit zip code doesn't seem to find the records. >>> We have entered the zip codes into one field thinking that the values >>> would behave as words. >>> >>> [search >>> db=admin/stores/ >>> stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[url][zipstore] >>> [/ url]&StoreZipCodetype=num] >>> >>> Should I consider a wo search like a keyword search instead of a data >>> lookup? >>> >>> David >>> -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
Various Problems (1997)
One more try (1997)
Unexpected error (1997)
View order not right (1997)
Classified (1999)
Ampersand (1997)
Emailer Problem (1999)
MacAuthorize order data fields WAS:How To question... (1997)
[WebDNA] webdna.us is blocked by Lightspeed Systems (2017)
BBEdit and WebCatalog 2.0? (1997)
Re:no [search] with NT (1997)
Running subtotal? (1998)
I'm Baaaaaaaaaack - Questions! (2000)
Banner DNA (1997)
searchable list archive (1997)
Linux -> OS X (2002)
possible, WebCat2.0 and checkboxes-restated (1997)
How true is this? (1999)
details (2003)
WebCat2b15MacPlugin - [protect] (1997)