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:
Ram WebDNA is using (2004)
[SearchString] problem with [search] context (1997)
HideIf ip= OR ip (1998)
[OT] Who's got a cool link (2002)
Generating unique SKU from [cart] - FIXED! (1997)
Typo in the Online Docs ... (1997)
StoreBuilder Shopping Cart (2000)
WC2b12: Yes, Formulas.db is for real (1997)
[WebDNA] thisAutonumber? (2011)
Fun with dates (1997)
TaxTotal (2003)
WebCat2b12 Mac.acgi--[searchstring] bug (1997)
Re:emailer 150 (1997)
Opinion: [input] should be called [output] ... (1997)
Forms & Tables (1998)
Web Catalog vs. ICAT (1997)
A little syntax help (1997)
Suggestions (1998)
Sorting Problems (2004)
Email...Thanks (1997)