Re: [WebDNA] search for not empty

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113089
interpreted = N
texte = 677 --001a114069a477d171053f957947 Content-Type: text/plain; charset=UTF-8 Yep, Thanksomuch! sfb Stephen F Braun sbraun1@twcny.rr.com On Sun, Oct 23, 2016 at 7:06 PM, Kenneth Grome wrote: > It's not working because you're searching for a SKU value that's > equal to 1 *OR* an OFFICER_1 value that's blank. Try appending > "rq" after "data" like this: > > [search db=my.db&geSKUdatarq=1&neOFFICER_1datarq=[blank]] > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > > > On 10/23/2016 02:20 PM, Stephen Braun wrote: > > Hi All, > > What is the correct syntax to include a 'not empty' or blank field > > in a search command? > > > > Here is what is not working: > > [search db=my.db&geSKUdata=1&neOFFICER_1data=[blank]] > > > > Thanks, > > sfb > > > > > > Stephen F Braun > > sbraun1@twcny.rr.com > > --------------------------------------------------------- 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 > --001a114069a477d171053f957947 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yep, =C2=A0Thanksomuch!
sfb


Stephen F Braun
sbraun1@twcny.rr.com

On Sun, Oct 23, 2016 at 7:06 PM, Kenneth Gro= me <ken@webdnasolutions.com> wrote:
It's not working because you're searching for a SK= U value that's
equal to 1 *OR* an OFFICER_1 value that's blank.=C2=A0 Try appending "rq" after "data" like this:

[search db=3Dmy.db&geSKUdatarq=3D1&neOFFICER_1datarq=3D[blank]= ]

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration



On 10/23/2016 02:20 PM, Stephen Braun wrote:
> Hi All,
> What is the correct syntax to include a 'not empty' or blank f= ield
> in a search command?
>
> Here is what is not working:
> [search db=3Dmy.db&geSKUdata=3D1&neOFFICER_1data=3D[blank= ]]
>
> Thanks,
> sfb
>
>
> Stephen F Braun
> sbraun1@twcny.rr.c= om <mailto:sbraun1@twcny.rr.= com>
> ------------------------------------------------= --------- 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 <talk@webdna.u= s>.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://ma= il.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 --001a114069a477d171053f957947-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] search for not empty (Stephen Braun 2016)
  2. Re: [WebDNA] search for not empty (Kenneth Grome 2016)
  3. Re: [WebDNA] search for not empty (Donovan Brooke 2016)
  4. [WebDNA] search for not empty (Stephen Braun 2016)
677 --001a114069a477d171053f957947 Content-Type: text/plain; charset=UTF-8 Yep, Thanksomuch! sfb Stephen F Braun sbraun1@twcny.rr.com On Sun, Oct 23, 2016 at 7:06 PM, Kenneth Grome wrote: > It's not working because you're searching for a SKU value that's > equal to 1 *OR* an OFFICER_1 value that's blank. Try appending > "rq" after "data" like this: > > [search db=my.db&geSKUdatarq=1&neOFFICER_1datarq=[blank]] > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > > > On 10/23/2016 02:20 PM, Stephen Braun wrote: > > Hi All, > > What is the correct syntax to include a 'not empty' or blank field > > in a search command? > > > > Here is what is not working: > > [search db=my.db&geSKUdata=1&neOFFICER_1data=[blank]] > > > > Thanks, > > sfb > > > > > > Stephen F Braun > > sbraun1@twcny.rr.com > > --------------------------------------------------------- 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 > --001a114069a477d171053f957947 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Yep, =C2=A0Thanksomuch!
sfb


Stephen F Braun
sbraun1@twcny.rr.com

On Sun, Oct 23, 2016 at 7:06 PM, Kenneth Gro= me <ken@webdnasolutions.com> wrote:
It's not working because you're searching for a SK= U value that's
equal to 1 *OR* an OFFICER_1 value that's blank.=C2=A0 Try appending "rq" after "data" like this:

[search db=3Dmy.db&geSKUdatarq=3D1&neOFFICER_1datarq=3D[blank]= ]

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration



On 10/23/2016 02:20 PM, Stephen Braun wrote:
> Hi All,
> What is the correct syntax to include a 'not empty' or blank f= ield
> in a search command?
>
> Here is what is not working:
> [search db=3Dmy.db&geSKUdata=3D1&neOFFICER_1data=3D[blank= ]]
>
> Thanks,
> sfb
>
>
> Stephen F Braun
> sbraun1@twcny.rr.c= om <mailto:sbraun1@twcny.rr.= com>
> ------------------------------------------------= --------- 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 <talk@webdna.u= s>.
To unsubscribe, E-mail to: <talk= -leave@webdna.us>
archives: http://ma= il.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 --001a114069a477d171053f957947-- . Stephen Braun

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:

WebCat2b13 Command Reference Doc error (1997) Help with Repost Data msg from form (1997) Cobalt and WebCatalog, do they work together? (2000) Cart Numbers (1997) WebCatalog Q & A pages (1997) NewCart+Search with one click ? (1997) Auto Fill Forms (2000) WebCat2b12 CGI Mac - [shownext] problem (1997) Cart Already Submitted (2003) What am I missing (1997) performans tests... (2001) Now when I send TeaRoom Order fields it does not post in Invoice. (1997) writing db to disk (1997) Webcat & SIMS (1998) CERT Advisory on malicious scripts (2000) Re2: frames & carts (1997) Sort Order on a page search (1997) WebCatalog for Postcards ? (1997) Trouble with formula.db + more explanation (1997) NT b19 sends extra MIME headers (1997)