Re: Searching on 3 different fields

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48787
interpreted = N
texte = Would this work? [search db=your.db&&group1field=str_ItemNumber+str_Keyword+str_Title&wogroup1data=lamps].... 'lamps' of course, could be any user-entered [search_term]-Dan ------------------------------------------------------------ http://www.StrongGraphicDesign.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------On Wed, 19 Mar 2003 13:46:15 -0800 Pedro Rivera wrote: >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_Title > >The 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/------------------------------------------------------------- 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)
Would this work? [search db=your.db&&group1field=str_ItemNumber+str_Keyword+str_Title&wogroup1data=lamps].... 'lamps' of course, could be any user-entered [search_term]-Dan ------------------------------------------------------------ http://www.StrongGraphicDesign.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------On Wed, 19 Mar 2003 13:46:15 -0800 Pedro Rivera wrote: >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_Title > >The 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/------------------------------------------------------------- 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/ Dan Strong

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:

Online reference (1997) WebDNA error. (2006) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Pithy questions on webcommerce & siteedit (1997) Sorting Numbers (1997) Shhh... (2006) WebCat2 - storing unformatted date data? (1997) Text data with spaces in them... (1997) WebCat: Paying affiliates commissions?? (2000) problems with 2 tags (1997) Re:Part 2 - [showif] if variable exists (1998) User .db Questions (1999) Nested searches (1998) Bug Report, maybe (1997) Restart of DBserver (1997) Hard Questions ? (1997) paymethod=cc allows all zeros (1999) WebTen and WebCat (1997) Associative lookup style? + bit more (1997) 4.5 Upgrade (2003)