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:
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:
Version clarification, please ... (1998)
Conversion Database Blues (2001)
Converting characters to numbers ... (1997)
DataBaseHelper Flawed (1997)
Appending current [date] to a database (1997)
Sorting by date (1997)
Document Contains No Data! (1997)
Bug or syntax error on my part? (1997)
Authorize.net, SIM, tcpconnect and applescript (2003)
Linux uninstall / reinstall (2003)
The old multiple selection bit (2000)
Using Plug-In while running 1.6.1 (1997)
5.0 feature request: Macro (2001)
Emailer Chokes on bad address (1997)
Multi shift click (1999)
Forwarding Orders Via Email (1998)
WebCatalog not running after upgrade (2000)
greater than or equal to (1997)
[Fwd: Rotating Banners ... (was LinkExchange)] (1997)
WebCat2b12 - nesting [tags] (1997)