Re: Searching Numbers

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58677
interpreted = N
texte = Sorry there was a typo in my example. Both search terms should have "rq" (required), or you could add AllReqd=T. Try this search: [search db=admin/stores/ stores.db&neidNumberdatarq=[blank]&waStoreZipCodeDatarq=[url][zipstore][ /url]&StoreZipCodeword=WW] - brian On Jun 28, 2004, at 12:25 PM, David Cate wrote: > Hi Brian, > > Thanks., but unfortunately that did not work either. I I haven't > worked much wth the WW function, but it does not work either. Instead, > this search string below just returns all off the stores and not the > ones that have the specific zip code that we are looking for. > > Here's my syntax and instead of returning just those that match the > zip-codes, the system now just renders all the files.... > > David > > On Jun 28, 2004, at 12:31 PM, Brian Fries wrote: > >> 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][zipstor >>>>> e][/ 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/ >> > > > ------------------------------------------------------------- > 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:

    
  1. Re: Searching Numbers (ZIP Code, Distance-based, Store ( David M. Dantowitz 2004)
  2. Re: Searching Numbers (ZIP Code, Distance-based, Store ( David M. Dantowitz 2004)
  3. Re: Searching Numbers ( Gary Krockover 2004)
  4. Re: Searching Numbers ( David Cate 2004)
  5. Re: Searching Numbers ( Terry Wilson 2004)
  6. Re: Searching Numbers ( Brian Fries 2004)
  7. Re: Searching Numbers ( Gary Krockover 2004)
  8. Re: Searching Numbers ( David Cate 2004)
  9. Re: Searching Numbers ( David Cate 2004)
  10. Re: Searching Numbers ( Brian Fries 2004)
  11. Re: Searching Numbers ( Terry Wilson 2004)
  12. Re: Searching Numbers ( David Cate 2004)
  13. Re: Searching Numbers ( Gary Krockover 2004)
  14. Re: Searching Numbers ( "Sal D'Anna" 2004)
  15. Re: Searching Numbers ( David Cate 2004)
  16. Re: Searching Numbers ( "Sal D'Anna" 2004)
  17. Re: Searching Numbers ( Gary Krockover 2004)
  18. Re: Searching Numbers ( David Cate 2004)
  19. Re: Searching Numbers ( Gary Krockover 2004)
  20. Re: Searching Numbers ( David Cate 2004)
  21. Re: Searching Numbers ( Gary Krockover 2004)
  22. Searching Numbers ( David Cate 2004)
  23. Re: searching numbers (PCS Technical Support 1998)
  24. Re: searching numbers (Kenneth Grome 1998)
Sorry there was a typo in my example. Both search terms should have "rq" (required), or you could add AllReqd=T. Try this search: [search db=admin/stores/ stores.db&neidNumberdatarq=[blank]&waStoreZipCodeDatarq=[url][zipstore][ /url]&StoreZipCodeword=WW] - brian On Jun 28, 2004, at 12:25 PM, David Cate wrote: > Hi Brian, > > Thanks., but unfortunately that did not work either. I I haven't > worked much wth the WW function, but it does not work either. Instead, > this search string below just returns all off the stores and not the > ones that have the specific zip code that we are looking for. > > Here's my syntax and instead of returning just those that match the > zip-codes, the system now just renders all the files.... > > David > > On Jun 28, 2004, at 12:31 PM, Brian Fries wrote: > >> 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][zipstor >>>>> e][/ 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/ >> > > > ------------------------------------------------------------- > 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/ 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:

Secure Server (1997) WebMerchant crashing and other WebMerchant problem (2000) [WebDNA] MIDDLE problems (2012) Problem displaying search result (1997) WebStar Secure on other machine (1997) Running 2 two WebCatalog.acgi's (1996) WCS Newbie question (1997) Does webcatalog recognise NULL values? (1998) hideif/showif causes error if wrapped around searches (2003) Date Search Problem (1999) WebCommerce: Folder organization ? (1997) Encrypt/decrypt bug in 3.0.5b12 (1999) [WebDNA] No more SQL in 7.1? (2012) WCS Newbie question (1997) Update quantity (2000) Header Problems (1998) SKU lookup (1997) [math] show=F exists? (1997) Missing from Docs [folderName] (1997) Signal Raised Error (Part III) (1997)