Re: Search for non blank fields

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 59427
interpreted = N
texte = Not to worry. Figured it out. Erol ----- Original Message ----- From: "Erol Guneri" To: "WebDNA Talk" Sent: Monday, September 20, 2004 12:23 PM Subject: Search for non blank fields > > Hi Guys, > > I am having a slight problem with a search. I have a database with products > that have 2 codes and am trying to generate a list of all of those where > code2 exists for certain suppliers. The search that I am using is: > > [search db=products.db&eqSupplierdatarq=[OrderFile > cart=[cart]][Header5][/OrderFile]&necode_2data=&code_2Summ=T&ProductNamesort > =1&startat=[OrderFile cart=[cart]][Header4][/OrderFile]&max=20] > > This code seems to find all the items for that supplier, including those > where code2 doesn't exist. I have tried changing necode_2data= to > necode_2data=[blank] and get the same result. > > Can anyone see where I have gone wrong? > > Thanks > > Erol > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search for non blank fields ( "Erol Guneri" 2004)
  2. Search for non blank fields ( "Erol Guneri" 2004)
Not to worry. Figured it out. Erol ----- Original Message ----- From: "Erol Guneri" To: "WebDNA Talk" Sent: Monday, September 20, 2004 12:23 PM Subject: Search for non blank fields > > Hi Guys, > > I am having a slight problem with a search. I have a database with products > that have 2 codes and am trying to generate a list of all of those where > code2 exists for certain suppliers. The search that I am using is: > > [search db=products.db&eqSupplierdatarq=[OrderFile > cart=[cart]][Header5][/OrderFile]&necode_2data=&code_2Summ=T&ProductNamesort > =1&startat=[OrderFile cart=[cart]][Header4][/OrderFile]&max=20] > > This code seems to find all the items for that supplier, including those > where code2 doesn't exist. I have tried changing necode_2data= to > necode_2data=[blank] and get the same result. > > Can anyone see where I have gone wrong? > > Thanks > > Erol > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://webdna.smithmicro.com/ > > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Erol Guneri"

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:

Kaaaaahhhhhhhnnnnnnn! (1997) search multiple fields from one input (1998) Extended [ConvertChars] (1997) Mac v. NT (1998) verify online (1997) [WebDNA] Error 500 with SUMM=T (2017) EmailProblem vs EmailComplete (2000) Shell Script needed (2003) Nested tags count question (1997) How to archive....? (1998) [getchars] questions (1997) WebCat2b13 Command Reference Doc error (1997) problems with 2 tags (1997) Displaying raw values (long) (1998) [format xs] freeze (1997) Convertchars Problem (2004) ShoppingCart clearing code (2004) WebCat2 beta 11 - new prefs ... (1997) Stats (2004) [OT] What log analyzer do you use? (2000)