Re:Searching for ALL / empty form field
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14610
interpreted = N
texte = Ken,Please have a look at http://secure.ims1.com/hlc/Search.tmplI guess what I'm getting at is this: I want the fields in which no value isspecified by the user to be ignored so that if a user doesn't select anyitems from the popups or type any text or numbers into the fields, all therecords will be returned.ANDIf the user does select an item from the a popup or types text or numbersinto a field then the search is performed on only those criteria.I do this all the time with Tango which allows one to specify that whenfields are empty they are not used as search criteria (allows you to setinclude empty to false). Am I making sense? I only want to find recordsthat have fields that match what is specified by the user in the searchform, but if they specify nothing, then I want all the records to bereturned.thanks, Paul>>Hi Paul,>>How many text input fields are there -- just one, or several? Are you>using datarq instead of data to require all fields to match? Do>you simply want to retrieve all records when nothing is entered into>a particular text input field?>>Sincerely, Ken Grome>WebDNA Solutions>http://www.smithmicro.com/webdnasolutions/>>. _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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:
Ken,Please have a look at http://secure.ims1.com/hlc/Search.tmplI guess what I'm getting at is this: I want the fields in which no value isspecified by the user to be ignored so that if a user doesn't select anyitems from the popups or type any text or numbers into the fields, all therecords will be returned.ANDIf the user does select an item from the a popup or types text or numbersinto a field then the search is performed on only those criteria.I do this all the time with Tango which allows one to specify that whenfields are empty they are not used as search criteria (allows you to setinclude empty to false). Am I making sense? I only want to find recordsthat have fields that match what is specified by the user in the searchform, but if they specify nothing, then I want all the records to bereturned.thanks, Paul>>Hi Paul,>>How many text input fields are there -- just one, or several? Are you>using datarq instead of data to require all fields to match? Do>you simply want to retrieve all records when nothing is entered into>a particular text input field?>>Sincerely, Ken Grome>WebDNA Solutions>http://www.smithmicro.com/webdnasolutions/>>. _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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:
WC Database Format (1997)
Fw: [SQL] and [index] mystery solved (2001)
WebDNA update from Smith Micro (2002)
Setting up a lightbox (2002)
Search Order? (2000)
Attn: Bug in GeneralStore example b15 (1997)
History of beta changes? (1999)
Review comparison by PC Magazine: Open for On-lineBusiness (1997)
Problem with version 4 browsers (1998)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Sorting Problems (2004)
Exclude by date - multiple (1997)
Using [Showif] tag. Mac (1997)
Formulas.db + Users.db (1997)
[WebDNA] possible bug? (db field named [width]) (2012)
[url] link (1998)
WebDNA - fun to compare (2005)
Cool new site (1996)
Realtor Search (2000)
Shopping Cart Problems (2000)