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:

U&P IIS concept (1998) Summary search -- speed (1997) OT: Advice (2003) [WebDNA] TextExpander snippets (2013) question: webdelivery folder and file (1997) OH MY GOD! (1998) A little syntax help (1997) [Semi-OT] Eaaaaaasy OSX FTP (2003) Storebuilder Seems to have just died (2003) authenticate (2002) WebCat b15 Mac plug-in (1997) buy 2 items get this free (2003) .html processing? (1998) WebCat2 - Getting to the browser's username/password data (1997) E-Commerce site for Canadian and US customers (1998) help with autenticate (1998) WebCatalog for guestbook ? (1997) dynamic PDF no longer working? (2004) Surprise x and y post args (1998) Preventing Merchant Settling ? (1997)