Re: Searching Numbers

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58648
interpreted = N
texte = 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 On Jun 27, 2004, at 11:48 PM, Gary Krockover wrote: > Could just be the email, but you do have some extra spaces in your > search string: > [search > db=admin/stores/ > stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZ > i pCodetype=num] > > > Should be: > > [search > db=admin/stores/ > stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZ > ipCodetype=num] > > What are the values for [zipstore]? Try [url][/url] that value as > well. > > GK > > > > At 10:19 PM 6/27/2004, you wrote: >> Boy. I thought that was going to solve the problem and forget to >> clarify data types too often, but I tried to update the file and still >> come up with the same problem. >> >> [search >> db=admin/stores/ >> stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&Store >> Zi pCodetype=num] >> >> Still the same problem though. Any other suggestions? >> >> 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/ > ------------------------------------------------------------- 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)
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 On Jun 27, 2004, at 11:48 PM, Gary Krockover wrote: > Could just be the email, but you do have some extra spaces in your > search string: > [search > db=admin/stores/ > stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZ > i pCodetype=num] > > > Should be: > > [search > db=admin/stores/ > stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&StoreZ > ipCodetype=num] > > What are the values for [zipstore]? Try [url][/url] that value as > well. > > GK > > > > At 10:19 PM 6/27/2004, you wrote: >> Boy. I thought that was going to solve the problem and forget to >> clarify data types too often, but I tried to update the file and still >> come up with the same problem. >> >> [search >> db=admin/stores/ >> stores.db&neidNumberdata=[blank]&eqStoreZipCodedatarq=[zipstore]&Store >> Zi pCodetype=num] >> >> Still the same problem though. Any other suggestions? >> >> 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/ > ------------------------------------------------------------- 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:

Not reading code (1997) Date problems-more (1997) Duplicates (1998) all records returned. (1997) Exclude by date - multiple (1997) Where is Typhoon 3.x? (2000) WebCatalog can't find database (1997) is sku a REQUIRED field on NT (1997) WebCommerce: Folder organization ? (1997) Append File help needed (2000) Newbie questions (1998) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) PIXO (1997) pop up menu's (1998) Cart -> Date and Time (2004) Help! WebCat2 bug (1997) RE: New WebCatalog Version !!! (1997) including an image through WebDNA (2005) Location of Webcat site in folder hierarchy (1997) Where is eudora plugin? (1998)