Searching on 3 different fields

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48786
interpreted = N
texte = Hi all,I'm trying to figure out what the best way is to search on 3 different fields, for example:str_ItemNumber, str_Keyword, str_TitleThe customer is searching for lamps, I don't want him to find amps I want him to find lamps. I need to see if any of those three fields has lamps any where.I also need it to sort by best match.Thanks in advanced.Pedro Rivera Webmaster www.pssl.com pedror@pssl.com 714-891-3990 Ext. 8174 11070 Valley View St. Cypress CA. 90630 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching on 3 different fields (Pedro Rivera 2003)
  2. Re: Searching on 3 different fields *CORRECTION* (Pedro Rivera 2003)
  3. Re: Searching on 3 different fields (Brian Fries 2003)
  4. Re: Searching on 3 different fields *CORRECTION* (Dan Strong 2003)
  5. Re: Searching on 3 different fields (Dan Strong 2003)
  6. Searching on 3 different fields (Pedro Rivera 2003)
Hi all,I'm trying to figure out what the best way is to search on 3 different fields, for example:str_ItemNumber, str_Keyword, str_TitleThe customer is searching for lamps, I don't want him to find amps I want him to find lamps. I need to see if any of those three fields has lamps any where.I also need it to sort by best match.Thanks in advanced.Pedro Rivera Webmaster www.pssl.com pedror@pssl.com 714-891-3990 Ext. 8174 11070 Valley View St. Cypress CA. 90630 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Pedro Rivera

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:

using listfiles to build a database? (2000) RE: [WebDNA] WebSite Examples (2008) Where's Cart Created ? (1997) Accepting credit cards (1997) Show shoppingcart after remove last item (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) ampersand (1998) Rendering out a page (1997) detecting already used [cart]? (2005) Security (1998) Grouping Fields in Context (1999) Re:2nd WebCatalog2 Feature Request (1996) PSC recommends what date format yr 2000??? (1997) can WC render sites out? (1997) [WebDNA] Adding hearder fields to a DB (2017) Emailer (WebCat2) (1997) Verifying both name and password (was: New Problem) (1997) WebCat2b13 Command Reference Doc error (1997) shipping help (1998) Help w/ Duplicating The General Store 5 times. (1997)