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:
Need relative path explanation (1997)
about this server and links to who (1997)
WebCat for Unix?? (1997)
Initiating NewCart (1997)
Protect (1997)
listfiles-looking for slick solution (1997)
OK, here goes... (1997)
Error Lob.db records error message not name (1997)
Multiple cart additions (1997)
Webcatalog error, Plug-in for Webstar (1996)
[WebDNA] Populate Bootstrap Modal with AJAX WebDNA (2015)
[WriteFile] problems (1997)
5.0 Pricing (2003)
unable to launch acgi in WebCat (1997)
process code only if accessed via POST (2006)
Number searching/formats (1998)
ShowNext problems (1998)
[WebDNA] cant't restart webcatalog missing libcrypto.so.0.9.8 (2014)
SKU Question (1999)
Feature request for next version (2005)