[WebDNA] Combining searches with blank and zero values?

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 106701
interpreted = N
texte = I'm trying to capture invalid prices and use a couple of searches: [search db=inventory.db&eqPRICEdatarq=[blank]] [search db=inventory.db&eqPRICEdatarq=0] Each works as I want separately, but ideally I'd have one search. Is there a way to combine these searches into one search? I've consulted the docs and tried a few variations, but nothing seems to click. Perhaps there's a way to search for any values that are not number? Thanks, Bill Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  2. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  3. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  4. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  5. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  6. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  7. Re: [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
  8. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  9. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  10. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  11. [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
I'm trying to capture invalid prices and use a couple of searches: [search db=inventory.db&eqPRICEdatarq=[blank]] [search db=inventory.db&eqPRICEdatarq=0] Each works as I want separately, but ideally I'd have one search. Is there a way to combine these searches into one search? I've consulted the docs and tried a few variations, but nothing seems to click. Perhaps there's a way to search for any values that are not number? Thanks, Bill William DeVaul

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:

[WebDNA] why this error when using [shownext] with a [table]? (2009) Secure server question (1997) includes and cart numbers (1997) WebCat2: Items xx to xx shown, etc. (1997) WebCat2: Items xx to xx shown, etc. (1997) Error 551 (2000) using showpage and showcart commands (1996) Multiple catalog databases and showcart (1997) Date format problems (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [format 40s]text[/format] doesn't work (1997) price carry over (1997) OSX Install error (2000) TCP Connect (2000) about this server and links to who (1997) emailer w/F2 (1997) problems with 2 tags (1997) emailer error type 103 (1997) A quickie question (1997)