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:

    
  1. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  2. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  3. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  4. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  5. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  6. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  7. Re: [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
  8. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  9. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  10. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  11. [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
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:

Pass a form (2003) Emailer help....! (1997) Searching for all records (1998) syntax for contains a word (2002) A little help on e-mail (HELP!!! :-) ) (1998) Re[4]: Problem with new formvariables (2000) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Emailer problems solved (1997) Version 4? (2000) SEARCH RESULTS (1998) Time comparison question (1998) Search in 2 or more catalogs (1997) Hummm .... (2002) WebCatalog NT beta 18 now available (1997) Sale on wholesale programming services ... (2006) Test (2003) TRAINING videos - Prove IT. (1998) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) [WebDNA] Mistake in web page instructions (2009) Location of Browser Info.txt file (1997)