Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106702
interpreted = N
texte = did you try: [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] ? (Not sure (without testing) how that search will handle records where = PRICE=3D[blank]) inside a founditems you can of course do all kinds of tests.. even = efficient ones in one statement.. ...but to do a single search to find *anything that is not a number*.. = hmm..=20 Your best bet might be to just use the 2 searches and throw the results = into a [table] and then do your desired operations on the [table]'s = records. (BTW, [blank] is not a number, but zero is, .. so your post was not = totally clear what you want. i.e. combining your 2 independent searches = does not seem to exactly equal the same thing as finding any records = where PRICE=3D(not a number)). On 2011-06-11, at 12:07 PM, William DeVaul wrote: > I'm trying to capture invalid prices and use a couple of searches: >=20 > [search db=3Dinventory.db&eqPRICEdatarq=3D[blank]] >=20 > [search db=3Dinventory.db&eqPRICEdatarq=3D0] >=20 > Each works as I want separately, but ideally I'd have one search. >=20 > 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. >=20 > Perhaps there's a way to search for any values that are not number? >=20 > 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 - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Associated Messages, from the most recent to the oldest:
did you try: [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] ? (Not sure (without testing) how that search will handle records where = PRICE=3D[blank]) inside a founditems you can of course do all kinds of tests.. even = efficient ones in one statement.. ...but to do a single search to find *anything that is not a number*.. = hmm..=20 Your best bet might be to just use the 2 searches and throw the results = into a [table] and then do your desired operations on the [table]'s = records. (BTW, [blank] is not a number, but zero is, .. so your post was not = totally clear what you want. i.e. combining your 2 independent searches = does not seem to exactly equal the same thing as finding any records = where PRICE=3D(not a number)). On 2011-06-11, at 12:07 PM, William DeVaul wrote: > I'm trying to capture invalid prices and use a couple of searches: >=20 > [search db=3Dinventory.db&eqPRICEdatarq=3D[blank]] >=20 > [search db=3Dinventory.db&eqPRICEdatarq=3D0] >=20 > Each works as I want separately, but ideally I'd have one search. >=20 > 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. >=20 > Perhaps there's a way to search for any values that are not number? >=20 > 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 - Govinda -------------- Old WebDNA talklist archives: http://dev.webdna.us/TalkListArchive/index.tpl?db=3Dwebdna-talk
Govinda
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:
This is an odd error (2001)
WebCat for Site Search? (1997)
[WebDNA] WebDNA crash and now emailer not working (2009)
[WebDNA] Local Development On Windows 8.1 (2015)
WebCat2final1 crashes (1997)
word count in HTML form textarea and linebreaks (2000)
WCS Newbie question (1997)
No luck with taxes (1997)
WebCommerce: Folder organization ? (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
elmer fudd (2004)
SKU number. (2000)
Who is John Jakovich? (1999)
HELP WITH DATES (1997)
Looking up two prices in database? (1997)
TCPConnect & Post (2002)
fyi - Linux 3.08 [ListFields] must not use path= (2000)
Make sure I understand this??? (1997)
WebCatalog plugin, FireSite and PIXO (2000)
Misc Stuff That Might Help (1997)