Re:Searching for ALL / empty form field
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14601
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=.>>
>All> red> green> blue> >>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 _/ _\_\_\_>_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_Try - AllJay Van Vark *******************************Pacific Coast Software | eCommerce (WebCatalog)11770 Bernardo Plaza Court | Site Hosting & DevelopmentSuite 453 | http://www.smithmicro.comSan Diego, CA 92128 *******************************619.675.1106** PGP key available upon request. **
Associated Messages, from the most recent to the oldest:
>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=.>>>All> red> green> blue> >>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 _/ _\_\_\_>_/_/_/_/_/_/_/_/_/_/_/_/_/_/ | \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_Try - AllJay Van Vark *******************************Pacific Coast Software | eCommerce (WebCatalog)11770 Bernardo Plaza Court | Site Hosting & DevelopmentSuite 453 | http://www.smithmicro.comSan Diego, CA 92128 *******************************619.675.1106** PGP key available upon request. **
Jay Van Vark
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:
Suggestions (1998)
vs (1997)
Running _every_ page through WebCat ? (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
Reserved Words (2003)
Converting native excel files (2001)
Aliases disable template updates ... :( (1999)
TEXTA-D (2003)
Error, 101 a DNS problem ? (1997)
international time (1997)
summarizing date search by month... (2000)
Text Areas, Sendmail and returns.... (2002)
WebCat2 - many [carts] on one template page? (1997)
shoppingcart reload qty (1997)
How does WebCatalog search the database? (1997)
Payments -> Bank Accounts (2005)
[WebDNA] Snow Leopard (2009)
[WebDNA] Detect the server's ip address? (2015)
Cart Numbers (1997)
[ot] Any One Want A WebDNA Billing Program? (2003)