Re: [WebDNA] Combining searches with blank and zero values?
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 106703
interpreted = N
texte = 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
Associated Messages, from the most recent to the oldest:
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
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:
PIXO Support (1997)
I give up!! (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
Country & Ship-to address & other fields ? (1997)
SSL (1998)
No luck with taxes (1997)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Practice runs ? (1997)
process SSI (1998)
More on the email templates (1997)
looking for developers with solutions (2000)
Great product and great job ! (1997)
test - ignore (2008)
Database changes (1998)
P1: How to make webcatalog more stable. - LONG (1999)
Editing the search string (1997)
Webcat Crashing Error 1701 (2000)
Removing [showif] makes a big difference in speed (1997)
Template transformed itself into a database? (1998)