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 aprice 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 aprice 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:
pc (1997)
format_to_days on NT (1997)
[SearchString] (1998)
[WebDNA] WebCatalog runaway process (2011)
cron script for housekeeping and running WebCatalog? (1999)
Never mind.... Searching blank fields problem (1999)
[WebDNA] WebDNA AJAX_Fileuploader (2013)
A quick look (2003)
RequiredFields template (1997)
ExpireDate Zero or Greater than Today (2006)
Spawning Holdup? (2000)
Addlineitems ... grrr (2004)
RedHat 9 & WebCatalog 4.5 (2004)
Overwriting databases bug in [closedatabase], garbage filescreated (1998)
searching multiple databases (1997)
E-Mailer (WebCatb15acgiMac) (1997)
Online reference (1997)
THANKS (1997)
Problems with webcat 2.01 for NT (1997)
[WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)