Re: Problems searching from a FORM

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14612
interpreted = N
texte = >No matter what I specify in the form, the results include all the records. >Granted, sometimes the results include the items searched for at the top, >but the rest of the items are all listed as well.This is as designed, but it's easy to change. Put rq after the data in each of your form field names. That means the field is required to match, otherwise it won't show up in the results at all.wscategorydata -> wscategorydatarqThe idea here is that there are usually two ways search for things: and vs. or, as in first name is Grant *and* last name is Hulbert vs. first name is Grant *or* last name is Hulbert. The first returns only 1 record, because it is much more restrictive. The second returns lots of records, because there are plenty of people whose first name is Grant.When you leave off the rq, you end up getting lots of matches, but they are sorted intelligently, similar to Lycos, in that the 'best match' records appear at the top of the list.Leaving a field entirely blank causes WebCatalog to ignore the field as though it weren't even specified in the 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:

    
  1. Re: Problems searching from a FORM (Kenneth Grome 1997)
  2. Re: Problems searching from a FORM (Paul Uttermohlen 1997)
  3. Re: Problems searching from a FORM (Grant Hulbert 1997)
  4. Re: Problems searching from a FORM (Kenneth Grome 1997)
  5. Problems searching from a FORM (Paul Uttermohlen 1997)
>No matter what I specify in the form, the results include all the records. >Granted, sometimes the results include the items searched for at the top, >but the rest of the items are all listed as well.This is as designed, but it's easy to change. Put rq after the data in each of your form field names. That means the field is required to match, otherwise it won't show up in the results at all.wscategorydata -> wscategorydatarqThe idea here is that there are usually two ways search for things: and vs. or, as in first name is Grant *and* last name is Hulbert vs. first name is Grant *or* last name is Hulbert. The first returns only 1 record, because it is much more restrictive. The second returns lots of records, because there are plenty of people whose first name is Grant.When you leave off the rq, you end up getting lots of matches, but they are sorted intelligently, similar to Lycos, in that the 'best match' records appear at the top of the list.Leaving a field entirely blank causes WebCatalog to ignore the field as though it weren't even specified in the 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:

Solve the Problem, get the code! (2001) Mime Headers for Mail (1998) Sorting by number (2001) [WebDNA] unix timestamp in WebDNA (2009) SEARCH Peram (2003) WebCat cannot handle compatible search parameters? (1997) FileMaker and WebCat - .hdr OK Merge not OK (1999) Show items based on login Password (2003) Kill the webcat process (2000) Server Error Question [bug?] (2004) Problem during evaluation of WebCatalog (1998) Writefile doesn't work, which permissions to use? (2005) encrypt (2000) Erotic Sites (1997) taxTotal, grandTotal (1997) Help name our technology! I found it (1997) instant cookies? (1999) urls (2005) Developer Edition - Connection Limit (2006) Press Release hit the NewsWire!!! (1997)