Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106704
interpreted = N
texte = Another trick I picked up from the list was to try and do [math] on results... non-numbers of course will reveal themselves this way too... I think the solution was to multiply by 1 or 0, I don't remember, but it worked. On 6/11/2011 9:34 AM, Dan Strong wrote: > I'm sure there's a better way but this is off the top of my head: > > [text]numbers=0123456789[/text] > [search db=inventory.db&nePRICEdatarq=showAll] > [founditems] > [hideif [url][PRICE][/url]^[numbers]] > [PRICE] > [/hideif] > [/founditems] > [/search] > > On 6/11/2011 9:07 AM, William DeVaul wrote: >> I'm trying to capture invalid prices and use a couple of searches: >> >> [search db=inventory.db&eqPRICEdatarq=[blank]] >> >> [search db=inventory.db&eqPRICEdatarq=0] >> >> Each works as I want separately, but ideally I'd have one search. >> >> 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. >> >> 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 > --------------------------------------------------------- > 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:
Another trick I picked up from the list was to try and do [math] on results... non-numbers of course will reveal themselves this way too... I think the solution was to multiply by 1 or 0, I don't remember, but it worked. On 6/11/2011 9:34 AM, Dan Strong wrote: > I'm sure there's a better way but this is off the top of my head: > > [text]numbers=0123456789[/text] > [search db=inventory.db&nePRICEdatarq=showAll] > [founditems] > [hideif [url][PRICE][/url]^[numbers]] > [PRICE] > [/hideif] > [/founditems] > [/search] > > On 6/11/2011 9:07 AM, William DeVaul wrote: >> I'm trying to capture invalid prices and use a couple of searches: >> >> [search db=inventory.db&eqPRICEdatarq=[blank]] >> >> [search db=inventory.db&eqPRICEdatarq=0] >> >> Each works as I want separately, but ideally I'd have one search. >> >> 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. >> >> 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 > --------------------------------------------------------- > 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
Dan Strong
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] can webdna's [grep] find and replace ONLY the literal (2012)
2.01 upgrade problems (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
How true is this? (1999)
US Postal Service API (2007)
Emailer Set Up (1997)
TPL Asks For Authentication (2004)
Problems passing [SKU] with $Replace in 2.0 (1997)
Help!!!! Purchases not going through! FIXED! (1997)
Emailer setup (1997)
Database Upload (2000)
Webcatalog not interpreting html pages (2002)
Smith Micro, possible listserver problems ... (2000)
RE: creating writefile data from a nested search (1997)
Is this possible, WebCat2.0 and checkboxes (1997)
Problems appending to database (1997)
SiteEdit Pro Update Announcement (1997)
ELF - eCommerce reporting system (2001)
PIXO (1997)
How do I specify a & character in Grep? (2000)