Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106705
interpreted = N
texte = I am looking for all "invalid" price records. 0, blank, has $ or some other non-number value. Right 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
wr= ote: > did you try: > > [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] > > ? > > (Not sure (without testing) how that search will handle records where PRI= CE=3D[blank]) > > inside a founditems you can of course do all kinds of tests.. even effici= ent ones in one statement.. > ...but to do a single search to find *anything that is not a number*.. hm= m.. > > Your best bet might be to just use the 2 searches and throw the results i= nto a [table] and then do your desired operations on the [table]'s records. > > (BTW, [blank] is not a number, but zero is, .. so your post was not total= ly clear what you want. =A0i.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)). > > 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 >
Associated Messages, from the most recent to the oldest:
I am looking for all "invalid" price records. 0, blank, has $ or some other non-number value. Right 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 wr= ote: > did you try: > > [search db=3Dinventory.db&lePRICEdatarq=3D0&PRICEtype=3Dnum] > > ? > > (Not sure (without testing) how that search will handle records where PRI= CE=3D[blank]) > > inside a founditems you can of course do all kinds of tests.. even effici= ent ones in one statement.. > ...but to do a single search to find *anything that is not a number*.. hm= m.. > > Your best bet might be to just use the 2 searches and throw the results i= nto a [table] and then do your desired operations on the [table]'s records. > > (BTW, [blank] is not a number, but zero is, .. so your post was not total= ly clear what you want. =A0i.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)). > > 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 >
William DeVaul
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:
[WebDNA] anyone get MaxMind geolite city working? (2012)
This might sound silly... (2000)
RE: webcat license???? (1997)
[OT] Happy Turkey Day! (2003)
Multiple fields on 1 input (1997)
f2 download problems (1997)
PCS Customer submissions ? (1997)
capitalize each word? (2002)
[HIDEIF] inside [FOUNDITEM] (1997)
Updating a database once per day - An example (1998)
All choices on IE different than Netscape (1997)
WebCatalog for Postcards ? (1997)
Case sensitivity and [showif] (1999)
Associative lookup style? + bit more (1997)
Video Performance Rights (1998)
[Sum] function? (1997)
serial number (1998)
WebCat2 several catalogs? (1997)
Webmerchant/Cybercash (2000)
Frames and WebCat (1997)