Re:Searching for ALL / empty form field *the FINAL answer*
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14611
interpreted = N
texte = >I guess what I'm getting at is this: I want the fields in which no value is >specified by the user to be ignored so that if a user doesn't select any >items from the popups or type any text or numbers into the fields, all the >records will be returned.Sorry about all the previous thrashing, Paul. It turns out we just misinterpreted your original request about blank fields. WebCatalog has always worked exactly the way you describe as above, but the only thing you need to add is the rq after data in your search form. Get rid of the [Blank] stuff; that's only used when you literally want to search for fields that are blank.Your original form was just fine, except that it was doing an or search instead of an and search.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>I guess what I'm getting at is this: I want the fields in which no value is >specified by the user to be ignored so that if a user doesn't select any >items from the popups or type any text or numbers into the fields, all the >records will be returned.Sorry about all the previous thrashing, Paul. It turns out we just misinterpreted your original request about blank fields. WebCatalog has always worked exactly the way you describe as above, but the only thing you need to add is the rq after data in your search form. Get rid of the [Blank] stuff; that's only used when you literally want to search for fields that are blank.Your original form was just fine, except that it was doing an or search instead of an and search.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Blocking form spam (2006)
[WAY OFF TOPIC] anybody live in Kansas? (2003)
Nesting format tags (1997)
shopping cart (2000)
PCS Frames (1997)
b12 cannot limit records returned and more. (1997)
did I miss anything (1997)
WebCat2final1 crashes (1997)
RE: Displaying Location (1997)
formatting dates from a field ... (1997)
Size limit for tmpl editor ? (1997)
Hard carriage convertion? (1998)
Webcatalog and foreign languages (1998)
External Images (1998)
SEARCH RESULTS (1998)
Keeping track of revision history, etc. (2005)
Resume Catalog ? (1997)
Online reference (1997)
Searching multiple criteria (2000)