Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106703
interpreted = N
texte = I'm sure there's a better way but this is off the top of my head: [text]numbers=0123456789[/text] [search db=inventory.db&nePRICEdatarq=showAll] [founditems] [hideif [url][PRICE][/url]^[numbers]] [PRICE] [/hideif] [/founditems] [/search] On 6/11/2011 9:07 AM, William DeVaul wrote: > 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 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
I'm sure there's a better way but this is off the top of my head: [text]numbers=0123456789[/text] [search db=inventory.db&nePRICEdatarq=showAll] [founditems] [hideif [url][PRICE][/url]^[numbers]] [PRICE] [/hideif] [/founditems] [/search] On 6/11/2011 9:07 AM, William DeVaul wrote: > 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 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Dan Strong
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:
WML (2000)
F3 crashing server (1997)
Emailer again & again (1997)
expired beta (1997)
FYI: SmithMicro Financial Report (2000)
showif and cart (1997)
Phonetic Search (2001)
raw=T is broken in [include] (1997)
[WriteFile] problems (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
apostrophe in search item (1997)
FW: ANother SHOWIF problem (1997)
Error.html (1997)
Progress !! WAS: Trouble with formula.db (1997)
Multiple 'Users.db' files not possible (1997)
Webcat Crashing Error 1701 (2000)
strange math (2004)
carriage returns in data (1997)
Text data with spaces in them... (1997)
OT?: Size issues (2001)