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:
If Else Statement... (2004)
Emailer (1998)
Updating fields from different platforms (1998)
[WebDNA] Cheers (2008)
UPDATE PROBLEM (1997)
WebCatalog f2 Installation (1997)
PCS Frames (1997)
WebCat B13 Mac CGI -- Frames question (1997)
multipart (2004)
WebCatalog v2.1.1 (1998)
Mail Server Needed. (1998)
CC Merchant suggestions?? (1997)
Online reference (1997)
textarea to page display (1998)
Getting total number of items ordered (1997)
Summary search -- speed (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
emailer w/F2 (1997)
WCS Newbie question (1997)
(ot) sitemap generator (1998)