Re: Search multiple fields

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 14625
interpreted = N
texte = Marko:First you have to specify which fields you'd like to group togther using the GroupXField tag:Next, perform your search using the field name GroupX. The search will treat multiple fields as if they were one:I hope this helps.John. >Hi, > >I’m trying to allow a search to access multiple fields within a databse. > >Mac running WebStar 2.1 and WebCatalog 2.1 MacOS8 > >The database is pretty standard: >SKU Title Description Company Category OSSupport Price Picture ... > >At the moment I have the following code below, one search for title and the other for description. I would like to keep the searches down to a minimum, ie I don’t want to a search for each of the fields. >I would like to have one search to gather results from more than one field. >Just like most search engines, you enter any text and it will search the whole database (but in my case I just need to search the following feilds: SKU, Title, Description, Company, Category, OSSupport). > >The manual does mention you can search multiple fields, but not how to do it. >The manual also mentions how to group fields, but not how to implement them into your code with examples. > > >
> > > > Search in Title for: >
> Items per page: > >
> > >
> > > > Search in Description for: >
> Items per page: > >
> > >Regards, >Marko > >---------------------------------- > Marko Bernyk >---------------------------------- > Senior System Engineer > Technical Services > Conexus Pty Ltd > Sydney, Australia > e-mail: marko@conexus.com.au > http://www.conexus.com.au >---------------------------------- >e-mail: marko.bernyk@earthling.net > http://www.conexus.com.au/marko/ John A. Hill Pacific Coast Software http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. search multiple fields from one input (Charlie Romero 1998)
  2. Re: Search multiple fields (John Hill 1997)
  3. Search multiple fields (Marko Bernyk 1997)
Marko:First you have to specify which fields you'd like to group togther using the GroupXField tag:Next, perform your search using the field name GroupX. The search will treat multiple fields as if they were one:I hope this helps.John. >Hi, > >I’m trying to allow a search to access multiple fields within a databse. > >Mac running WebStar 2.1 and WebCatalog 2.1 MacOS8 > >The database is pretty standard: >SKU Title Description Company Category OSSupport Price Picture ... > >At the moment I have the following code below, one search for title and the other for description. I would like to keep the searches down to a minimum, ie I don’t want to a search for each of the fields. >I would like to have one search to gather results from more than one field. >Just like most search engines, you enter any text and it will search the whole database (but in my case I just need to search the following feilds: SKU, Title, Description, Company, Category, OSSupport). > >The manual does mention you can search multiple fields, but not how to do it. >The manual also mentions how to group fields, but not how to implement them into your code with examples. > > >
> > > [cart]> > Search in Title for: >
> Items per page: > >
> > >
> > > [cart]> > Search in Description for: >
> Items per page: > >
> > >Regards, >Marko > >---------------------------------- > Marko Bernyk >---------------------------------- > Senior System Engineer > Technical Services > Conexus Pty Ltd > Sydney, Australia > e-mail: marko@conexus.com.au > http://www.conexus.com.au >---------------------------------- >e-mail: marko.bernyk@earthling.net > http://www.conexus.com.au/marko/ John A. Hill Pacific Coast Software http://www.smithmicro.com John Hill

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:

WebCat Problem? (1999) (1999) Need help with emailer- 2 issues (1997) starting news site + small store (2000) dates as search criteria (2000) list/menus (2000) webcat plugin issue (2001) Merging databases (1997) Clear command and ShoppingCart.tmpl (1997) Re(5): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) For those of you not on the WebCatalog Beta... (1997) Assign Variable Value (1998) Not really WebCat (1997) Webmerchant confirmation hooks? (1997) Mac Vs WindowsNT (1997) guest book problem (2000) [Semi-OT] Kinda cool tool (how does it work?) (2004) how to use encrypt and searching (1998) access denied problem (1997) Math Bug (1999)