Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106708
interpreted = N
texte = you'd have to loop through those chars to do something like that, right? PRICE is not going to ever contain the literal "$-or-whatever-else-@". = (Not even a bad price that he is trying to find.) On 2011-06-11, at 12:48 PM, Dan Strong wrote: > Ah, more appropriately then: >=20 > [text]invalidChars=3D$-or-whatever-else-@[/text] > [search db=3Dinventory.db&nePRICEdatarq=3DshowAll] > [founditems] > [showif [url][PRICE][/url]^[invalidChars]] > [PRICE] > [/showif] > [/founditems] > [/search] >=20 > But the [math] trick is much easier... >=20 > On 6/11/2011 9:39 AM, William DeVaul wrote: >> I am looking for all "invalid" price records. 0, blank, has $ or = some >> other non-number value. Right now they are all separate searches. >>=20 >> Essentially, I want a search for field is not a number value. >>=20 >> Bill >>=20 >> On Sat, Jun 11, 2011 at 12:27 PM, = Govinda
wrote: >>> did you try: >>>=20 >>> [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] >>>=20 >>> ? >>>=20 >>> (Not sure (without testing) how that search will handle records = where PRICE=3D[blank]) >>>=20 >>> 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. >>>=20 >>> (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)). >>>=20 >>> On 2011-06-11, at 12:07 PM, William DeVaul wrote: >>>=20 >>>> 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 >>>=20 >>> --------------------------------------------------------- >>> 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 >>>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:
you'd have to loop through those chars to do something like that, right? PRICE is not going to ever contain the literal "$-or-whatever-else-@". = (Not even a bad price that he is trying to find.) On 2011-06-11, at 12:48 PM, Dan Strong wrote: > Ah, more appropriately then: >=20 > [text]invalidChars=3D$-or-whatever-else-@[/text] > [search db=3Dinventory.db&nePRICEdatarq=3DshowAll] > [founditems] > [showif [url][PRICE][/url]^[invalidChars]] > [PRICE] > [/showif] > [/founditems] > [/search] >=20 > But the [math] trick is much easier... >=20 > On 6/11/2011 9:39 AM, William DeVaul wrote: >> I am looking for all "invalid" price records. 0, blank, has $ or = some >> other non-number value. Right now they are all separate searches. >>=20 >> Essentially, I want a search for field is not a number value. >>=20 >> Bill >>=20 >> On Sat, Jun 11, 2011 at 12:27 PM, = Govinda wrote: >>> did you try: >>>=20 >>> [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] >>>=20 >>> ? >>>=20 >>> (Not sure (without testing) how that search will handle records = where PRICE=3D[blank]) >>>=20 >>> 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. >>>=20 >>> (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)). >>>=20 >>> On 2011-06-11, at 12:07 PM, William DeVaul wrote: >>>=20 >>>> 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 >>>=20 >>> --------------------------------------------------------- >>> 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 >>>=20 >> --------------------------------------------------------- >> 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 > --------------------------------------------------------- > 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:
RE: creating writefile data from a nested search (1997)
CA tax rates update (1998)
AOL access problems (1998)
math on date? (1997)
Re:FYI: Error message (1996)
Chatroom (2000)
TCP Send workflow question (2005)
new cart IDs being assigned somehow (1997)
Site Builder & IE Mac (2004)
WebCat2 - many [carts] on one template page? (1997)
Emailer port change (1997)
WC2b15 File Corruption (1997)
2 databases (1997)
Problem with summary on date / inconsequent webcat behaviour (1998)
Bug in v5.1? (2003)
PSC recommends what date format yr 2000??? (1997)
Search all Fields in a db (1997)
Need relative path explanation (1997)
[LOOKUP] (1997)
maximum characters in [username]? (2002)