Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106711
interpreted = N
texte = The problem with the multiply by 0 is that it will not differentiate a price with 0 from one with 100 as anything multiplies will equal 0. Unless I forgot my multiplications table. On Sat, Jun 11, 2011 at 10:29 AM, Dan Strong
wrote: > 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-@". >> =A0(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=3D$-or-whatever-else-@[/text] >>> =A0 =A0[search db=3Dinventory.db&nePRICEdatarq=3DshowAll] >>> =A0 =A0 =A0 =A0[founditems] >>> =A0 =A0 =A0 =A0 =A0 =A0[showif [url][PRICE][/url]^[invalidChars]] >>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0[PRICE] >>> =A0 =A0 =A0 =A0 =A0 =A0[/showif] >>> =A0 =A0 =A0 =A0[/founditems] >>> =A0 =A0[/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. =A00, blank, has $ or so= me >>>> other non-number value. =A0Right 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 >>>> =A0 wrote: >>>>> >>>>> 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.. >>>>> >>>>> Your best bet might be to just use the 2 searches and throw the resul= ts >>>>> into a [table] and then do your desired operations on the [table]'s r= ecords. >>>>> >>>>> (BTW, [blank] is not a number, but zero is, .. so your post was not >>>>> totally clear what you want. =A0i.e. combining your 2 independent sea= rches >>>>> 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: >>>>>> >>>>>> [search db=3Dinventory.db&eqPRICEdatarq=3D[blank]] >>>>>> >>>>>> [search db=3Dinventory.db&eqPRICEdatarq=3D0] >>>>>> >>>>>> Each works as I want separately, but ideally I'd have one search. >>>>>> >>>>>> Is there a way to combine these searches into one search? =A0I'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=3Dwebdna-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=3Dwebdna-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 >
Associated Messages, from the most recent to the oldest:
The problem with the multiply by 0 is that it will not differentiate a price with 0 from one with 100 as anything multiplies will equal 0. Unless I forgot my multiplications table. On Sat, Jun 11, 2011 at 10:29 AM, Dan Strong wrote: > 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-@". >> =A0(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=3D$-or-whatever-else-@[/text] >>> =A0 =A0[search db=3Dinventory.db&nePRICEdatarq=3DshowAll] >>> =A0 =A0 =A0 =A0[founditems] >>> =A0 =A0 =A0 =A0 =A0 =A0[showif [url][PRICE][/url]^[invalidChars]] >>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0[PRICE] >>> =A0 =A0 =A0 =A0 =A0 =A0[/showif] >>> =A0 =A0 =A0 =A0[/founditems] >>> =A0 =A0[/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. =A00, blank, has $ or so= me >>>> other non-number value. =A0Right 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 >>>> =A0 wrote: >>>>> >>>>> 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.. >>>>> >>>>> Your best bet might be to just use the 2 searches and throw the resul= ts >>>>> into a [table] and then do your desired operations on the [table]'s r= ecords. >>>>> >>>>> (BTW, [blank] is not a number, but zero is, .. so your post was not >>>>> totally clear what you want. =A0i.e. combining your 2 independent sea= rches >>>>> 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: >>>>>> >>>>>> [search db=3Dinventory.db&eqPRICEdatarq=3D[blank]] >>>>>> >>>>>> [search db=3Dinventory.db&eqPRICEdatarq=3D0] >>>>>> >>>>>> Each works as I want separately, but ideally I'd have one search. >>>>>> >>>>>> Is there a way to combine these searches into one search? =A0I'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=3Dwebdna-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=3Dwebdna-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 >
Ronald Kirkland
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:
Snake Bites (1997)
encryption in browser? (1998)
2.1 Stuff (1998)
Problems with Price field (1997)
RE: Displaying Location (1997)
NT considerations (1997)
Problems getting parameters passed into email. (1997)
and vs or vs not (1998)
ShowNext Page Style (2003)
japanese characters (1997)
Help name our technology! (1997)
Q: how long for answers to the WebDNA-Talk list? (1997)
Applying discounts as more items are added... (1997)
japanese characters (1997)
[WebDNA] OPENDKIM (2014)
Separate SSL Server (1997)
WC2f3 (1997)
[WebDNA] Grep (2009)
summ=T (2003)
syntax question, not in online refernce (1997)