Re: search double negative comparison
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36583
interpreted = N
texte = There is probably One way to do this, unfortunately I don't that,but I know Another Way to do it :)[SEARCH db=db/ggg.db&neFIRSTNAMEdata=john][founditems][HIDEIF [firstname]=dean][firstname]
[/hideif][/founditems][/search][CLOSEDATABASE db/ggg.db]my db isGGGID FIRSTNAME LASTNAME1 John Doe2 John Smith3 Dean Doe4 Dean Smith5 Robert Smith6 David Black7 Jim Black8 Paul RedHope this helps You...Anup Setty----- Original Message -----From: Robert Kudrle
To: WebCatalog Talk Sent: Friday, June 22, 2001 4:22 PMSubject: search double negative comparisonI'm trying to search for all records which has a field MAINSITEDATABASE thatdoesn't contain the values professionalsdatabase.db or doctorsdatabase.db.For some reason my DNA statement returns all records. It works correctly ifI take out one of the variables but not when I have both. Anyone have anidea.[Searchdb=databases/search.db&neMAINSITEDATABASEdata=[url]professionalsdatabase.db[/url]&neMAINSITEDATABASEdata=[url]doctorsdatabase.db[/url]]Thanks to anyone who can help. Otherwise maybe I should take the afternoonoff.--Robert KudrleCoil, Counts, Ford & Cheneyrjk27@ccfc.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 toWeb Archive of this list is at: http://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
There is probably One way to do this, unfortunately I don't that,but I know Another Way to do it :)[SEARCH db=db/ggg.db&neFIRSTNAMEdata=john][founditems][HIDEIF [firstname]=dean][firstname]
[/hideif][/founditems][/search][CLOSEDATABASE db/ggg.db]my db isGGGID FIRSTNAME LASTNAME1 John Doe2 John Smith3 Dean Doe4 Dean Smith5 Robert Smith6 David Black7 Jim Black8 Paul RedHope this helps You...Anup Setty----- Original Message -----From: Robert Kudrle To: WebCatalog Talk Sent: Friday, June 22, 2001 4:22 PMSubject: search double negative comparisonI'm trying to search for all records which has a field MAINSITEDATABASE thatdoesn't contain the values professionalsdatabase.db or doctorsdatabase.db.For some reason my DNA statement returns all records. It works correctly ifI take out one of the variables but not when I have both. Anyone have anidea.[Searchdb=databases/search.db&neMAINSITEDATABASEdata=[url]professionalsdatabase.db[/url]&neMAINSITEDATABASEdata=[url]doctorsdatabase.db[/url]]Thanks to anyone who can help. Otherwise maybe I should take the afternoonoff.--Robert KudrleCoil, Counts, Ford & Cheneyrjk27@ccfc.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 toWeb Archive of this list is at: http://search.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://search.smithmicro.com/
Anup Setty
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:
Document contains no data... (1999)
Not really WebCat (1997)
easy numfound search? (2001)
WebCat editing, SiteGuard & SiteEdit (1997)
Frames and WebCat (1997)
Checking for blank form fields 2nd idea (1998)
Text in coloums... (2000)
WebDNA-Talk Digests (1997)
More on IE5 (2000)
Smith Micro - no competition (2000)
href name= link from dynamic URL possible? (1998)
getchars broken? (1997)
WebCatalog 4.0.1 has been released! (2000)
searchable list archive (1997)
RE: Error: template (1997)
[Sum] function? (1997)
Email Scavengers (2003)
Multiple prices (1997)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Snake Bites (1997)