search double negative comparison
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36595
interpreted = N
texte = I'm trying to search for all records which has a field MAINSITEDATABASE that doesn't contain the values professionalsdatabase.db or doctorsdatabase.db.For some reason my DNA statement returns all records. It works correctly if I take out one of the variables but not when I have both. Anyone have an idea. [Search db=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 afternoon off. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@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 to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I'm trying to search for all records which has a field MAINSITEDATABASE that doesn't contain the values professionalsdatabase.db or doctorsdatabase.db.For some reason my DNA statement returns all records. It works correctly if I take out one of the variables but not when I have both. Anyone have an idea. [Search db=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 afternoon off. -- Robert Kudrle Coil, Counts, Ford & Cheney rjk27@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 to Web Archive of this list is at: http://search.smithmicro.com/
Robert Kudrle
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:
Encyption mail was Suggestions for Topics ... (1998)
Not really WebCat (1997)
WebDelivery downloads alias, not original ? (1997)
Stats (2004)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Search returns all, not 20 (1997)
many-to-one problem (1998)
shipcost (1997)
Carriage returns in [text] variables (1999)
How to append text after the sign & (1997)
Multiple 'Users.db' files not possible (1997)
Template transformed itself into a database? (1998)
shownext example (2001)
[WebDNA] File Include HTM (2008)
Re:quit command on NT (1997)
Referrer or maybe another way..... (2005)
2.1b3 --> way slow (1997)
Shopping carts and reloading pages (1997)
checksum for credit cards? (1997)
Substitutes for [text]? (2000)