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 PMSubject: Search for non blank fields>> Hi Guys,>> I am having a slight problem with a search. I have a database withproducts> 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:
Not to worry. Figured it out.Erol----- Original Message -----From: "Erol Guneri" To: "WebDNA Talk" Sent: Monday, September 20, 2004 12:23 PMSubject: Search for non blank fields>> Hi Guys,>> I am having a slight problem with a search. I have a database withproducts> 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)