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:

ShowNext for method=POST (1997) Simple Browser Upload (2002) flushdatabases (2000) WCf2 and nested tags (1997) What's wrong with this? (2005) Format Thousands Looks Busted (2000) add line item context and showitems (1998) RE: Missing contexts on NT (1997) Changing to a windows mounted share from a Mac OS X machine (2002) [WebDNA] talklist size... (2009) Bug Report, maybe (1997) WebCatalog can't find database (1997) Re:E-mailer application times out (1998) Check if file exists (2000) Running _every_ page through WebCat-error.html (1997) 4D Database (1997) Problems when user hit back (2000) Now you see it now you donīt (1997) How To question on setting up downloads (1997) WebCat for mass emailings (1997)