Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106710
interpreted = N
texte = Yeah, you're right... that's what I meant. The multiplying by 0 solution is best though, IMO. On 6/11/2011 10:21 AM, Govinda wrote: > 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: >> >> [text]invalidChars=$-or-whatever-else-@[/text] >> [search db=inventory.db&nePRICEdatarq=showAll] >> [founditems] >> [showif [url][PRICE][/url]^[invalidChars]] >> [PRICE] >> [/showif] >> [/founditems] >> [/search] >> >> But the [math] trick is much easier... >> >> 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. >>> >>> Essentially, I want a search for field is not a number value. >>> >>> Bill >>> >>> On Sat, Jun 11, 2011 at 12:27 PM, Govinda
wrote: >>>> did you try: >>>> >>>> [search db=inventory.db&lePRICEdatarq=0&PRICEtype=num] >>>> >>>> ? >>>> >>>> (Not sure (without testing) how that search will handle records where PRICE=[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.. >>>> >>>> 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=(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: >>>>> >>>>> [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 >>>> - Govinda >>>> -------------- >>>> Old WebDNA talklist archives: >>>> http://dev.webdna.us/TalkListArchive/index.tpl?db=webdna-talk >>>> >>>> --------------------------------------------------------- >>>> 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 >> --------------------------------------------------------- >> 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=webdna-talk > > --------------------------------------------------------- > 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:
Yeah, you're right... that's what I meant. The multiplying by 0 solution is best though, IMO. On 6/11/2011 10:21 AM, Govinda wrote: > 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: >> >> [text]invalidChars=$-or-whatever-else-@[/text] >> [search db=inventory.db&nePRICEdatarq=showAll] >> [founditems] >> [showif [url][PRICE][/url]^[invalidChars]] >> [PRICE] >> [/showif] >> [/founditems] >> [/search] >> >> But the [math] trick is much easier... >> >> 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. >>> >>> Essentially, I want a search for field is not a number value. >>> >>> Bill >>> >>> On Sat, Jun 11, 2011 at 12:27 PM, Govinda wrote: >>>> did you try: >>>> >>>> [search db=inventory.db&lePRICEdatarq=0&PRICEtype=num] >>>> >>>> ? >>>> >>>> (Not sure (without testing) how that search will handle records where PRICE=[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.. >>>> >>>> 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=(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: >>>>> >>>>> [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 >>>> - Govinda >>>> -------------- >>>> Old WebDNA talklist archives: >>>> http://dev.webdna.us/TalkListArchive/index.tpl?db=webdna-talk >>>> >>>> --------------------------------------------------------- >>>> 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 >> --------------------------------------------------------- >> 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=webdna-talk > > --------------------------------------------------------- > 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:
Exclamation point (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Search in 2 or more catalogs (1997)
Deleting Orders (1997)
WebCatalog for Postcards ? (1997)
Quickie question on the email templates (1997)
IP lookup tool via tcpconnect (2002)
webmerch and serials - almost there (1997)
Off Topic: Frames Killer? (1998)
WC2b15 File Corruption (1997)
NT error logs (1997)
Sendmail truncation in Eudora Clients (1998)
Autoreturn Submit? (1997)
Re:no [search] with NT (1997)
Corruption in images (2004)
Trouble with formula.db (1997)
A question on sub-categories (1997)
checksum for credit cards? (1997)
[append] (1997)