Re:Searching for ALL / empty form field *the FINAL answer*
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14626
interpreted = N
texte = Like Magic!Thank you everyone for helping me learn the magic of putting rq after data.This is really simple, powerful stuff. I'm encouraged to the point that I'll probably convert our big SQL databases over to WebCat!Paul>>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/ _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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:
Like Magic!Thank you everyone for helping me learn the magic of putting rq after data.This is really simple, powerful stuff. I'm encouraged to the point that I'll probably convert our big SQL databases over to WebCat!Paul>>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/ _/_/_/_/_/_/_/_/_/_/_/_/|\_\_\_\_\_\_\_\_\_\_\_\_ _/_/_/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:
[carts] and databases (1997)
date formatting for CC card expiration date check (1998)
[OT] md5 or sha-1 on OSX (2007)
Some Questions (1997)
Whats going on with my SERIAL NUMBER??? (1998)
Building Calendars (1997)
Online reference (1997)
WCS Newbie question (1997)
WebCat2.0 [format thousands .0f] no go (1997)
RE: Upload and WebCat (1998)
WebCatalog for Mac 2.0.1 Released (1997)
HomePage Caution (1997)
WebCat2final1 crashes (1997)
Permission denied? (2004)
[WebDNA] Foreign characters (2009) (2009)
Formating found categories (1997)
syntax question, not in online refernce (1997)
WebCat2: Found Items syntax, etc. (1997)
products db philosophy (2001)
FS WebCatalaog license (2000)