Re: [WebDNA] search for not empty

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 113088
interpreted = N
texte = 676 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 . 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)
676 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 . Kenneth Grome

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:

Emailer help....! (1997) Newbie question (1998) [WebDNA] [createdate] displays today's date on Ubuntu 14.04 / (2014) Location of Webcat site in folder hierarchy (1997) Can ShowNext do this? (2000) ShowNext (1997) show all problem (1997) creating a 60 fields database (1997) # fields limited? (1997) TCPConnect strange behaviour (2004) Windows: Apache in place of IIS (2002) Greeting Card System (2000) Share cost of training videos! (1998) Signal Raised error (1997) still having shipCost.db Problem (1997) WebCatalog can't find database (1997) Help needed! (1998) I'm tired of all this! (2000) Still Stumped on ShowNext...HELP! (1997) WebDNA-generated email headers (2003)