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 does it have the value NothingIf your field contains the value nothing you should use neFIELDNAMEdata=nothing, and if it's empty neFIELDNAMEdata=[blank]or if you need to be sure that neither the records where the FIELDNAME is blank or has the value nothing you could do an AND search, defining that FIELDNAME should not be equal to [blank] and FIELDNAME should not be equal to 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.edu Konsulentfirmaet Bech.dk Dynamic HTML, WebDNA programming, Lasso & Filemaker Pro developement Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching for Nothing (PCS Technical Support 1998)
  2. Re: Searching for Nothing (Martin Gertz Bech 1998)
  3. Re: Searching for Nothing (Peter Ostry 1998)
  4. Searching for Nothing (Howard Wolosky 1998)
Is your field normally empty, when it doesn't have a real value or does it have the value NothingIf your field contains the value nothing you should use neFIELDNAMEdata=nothing, and if it's empty neFIELDNAMEdata=[blank]or if you need to be sure that neither the records where the FIELDNAME is blank or has the value nothing you could do an AND search, defining that FIELDNAME should not be equal to [blank] and FIELDNAME should not be equal to 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.edu Konsulentfirmaet Bech.dk Dynamic 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)