Re: Searching for Nothing
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20226
interpreted = N
texte = Is your field normally empty, when it doesn't have a real value or doesit have the value NothingIf your field contains the value nothing you should useneFIELDNAMEdata=nothing, and if it's empty neFIELDNAMEdata=[blank]or if you need to be sure that neither the records where the FIELDNAME isblank or has the value nothing you could do an AND search, defining thatFIELDNAME should not be equal to [blank] and FIELDNAME should not be equalto nothingThis is just a guess, not tested, but i think it would work...../Martin>What is the method taken to search for nothing in a field of a database?>I'm trying to do it based off of a form, but when I use a modified version>of the search form created by the database helper, if they type nothing>into the field, and select not equal to for the search type, it just>doesn't work. Any ideas?>>Howard Wolosky>------------------------->Rutgers University>Class of 2001>hwolosky@eden.rutgers.eduKonsulentfirmaet Bech.dkDynamic HTML, WebDNA programming, Lasso & Filemaker Pro developement
Associated Messages, from the most recent to the oldest:
Is your field normally empty, when it doesn't have a real value or doesit have the value NothingIf your field contains the value nothing you should useneFIELDNAMEdata=nothing, and if it's empty neFIELDNAMEdata=[blank]or if you need to be sure that neither the records where the FIELDNAME isblank or has the value nothing you could do an AND search, defining thatFIELDNAME should not be equal to [blank] and FIELDNAME should not be equalto nothingThis is just a guess, not tested, but i think it would work...../Martin>What is the method taken to search for nothing in a field of a database?>I'm trying to do it based off of a form, but when I use a modified version>of the search form created by the database helper, if they type nothing>into the field, and select not equal to for the search type, it just>doesn't work. Any ideas?>>Howard Wolosky>------------------------->Rutgers University>Class of 2001>hwolosky@eden.rutgers.eduKonsulentfirmaet Bech.dkDynamic HTML, WebDNA programming, Lasso & Filemaker Pro developement
Martin Gertz Bech
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:
Parse question (2005)
[ConvertChars] problem (1997)
different ship dates and shopping carts -- how to? (1997)
[protect] on NT? (1997)
emailer (1997)
Funny Submissions From a Form Page (1999)
Change 2.0 to 2.1: Carts files not written to disk automatically (1998)
ODBC to WebCat (2000)
Bug Report, maybe (1997)
This message couldn't reach the list! (multi-column (1998)
[SHOWIF] (1997)
WebDNA Solutions ... sorry! (1997)
OLD ORDERS (1998)
Searching multiple fields from one form field (1997)
[Reload mydata.db] (1998)
[WebDNA] TCP HTTP/1.1 questions (2011)
'RequiredField' Question (1998)
Links and urls (2005)
multi-paragraph fields (1997)
Multiple catalog databases and showcart (1997)