Searching for ALL / empty form field

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14600
interpreted = N
texte = Hi,In a form that has options to search the field color (this is just an example) I have an option for all with the value=.When ALL is selected, the search finds only records where COLOR is empty because the search argument is looking for a record where &color=&. OUCH!How do I set it up so that when a field is left blank or I want it to ignore certain criteria the search works properly?thanks, Paul _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Associated Messages, from the most recent to the oldest:

    
  1. Re:Searching for ALL / empty form field *the FINAL answer* (Paul Uttermohlen 1997)
  2. Re:Searching for ALL / empty form field (Kenneth Grome 1997)
  3. Re:Searching for ALL / empty form field (John Hill 1997)
  4. Re:Searching for ALL / empty form field *the FINAL answer* (Grant Hulbert 1997)
  5. Re:Searching for ALL / empty form field (Paul Uttermohlen 1997)
  6. Re:Searching for ALL / empty form field (Kenneth Grome 1997)
  7. Re:Searching for ALL / empty form field (Jay Van Vark 1997)
  8. Re:Searching for ALL / empty form field (Paul Uttermohlen 1997)
  9. Re:Searching for ALL / empty form field (Jay Van Vark 1997)
  10. Re:Searching for ALL / empty form field (Paul Uttermohlen 1997)
  11. Re:Searching for ALL / empty form field (Jay Van Vark 1997)
  12. Searching for ALL / empty form field (Paul Uttermohlen 1997)
Hi,In a form that has options to search the field color (this is just an example) I have an option for all with the value=.When ALL is selected, the search finds only records where COLOR is empty because the search argument is looking for a record where &color=&. OUCH!How do I set it up so that when a field is left blank or I want it to ignore certain criteria the search works properly?thanks, Paul _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/Paul Uttermohlen, Internet Marketspace, Inc. \_\_\_\_ _/_/_/ mailto:paul@ims1.com - Website Development \_\_\_\_ _/_/_/ Business - _\_\_\_\_\_\_\_\_\_\_ _/_/_/ Real Estate - _\_\_\_\_ _/_/_/Websites - Children _/ _\_\_\_ _/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_ Paul Uttermohlen

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:

[SEARCH] Context for SKU prices not working... (1998) Problem with Formulas.db (1998) Umm...about those log files? (Off Topic) (1997) Future of WebDNA (was urls) (2005) Thanks and Big News!!! (1997) Two submit buttons ? (1997) SOP for WebDNA talk - MSNBot Crashing (2004) Help! I've fallen in Structured Query Language and can'tget (2002) [WebDNA] lookup in tables defined in functions - bug? (2016) [LOOKUP] (1997) Help! WebCat2 bug (Ben's input) (1997) [WebDNA] client request (2010) spawn (1998) Notepad problems (1998) WCS Newbie question (1997) Error Msg (1997) restart needed???? (1997) [subtotal] and others (1997) Protect (1997) Same Table Opened Twice (2003)