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:

3.0 [TEXT] variables (1998) [delete] problem (1997) View order not right (1997) Review comparison by PC Magazine: Open for On-line Business (1997) broken [include]s (1998) Wanted: More Math Functions (or, Can You Solve This?) (1997) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) Image maps/Webcat (1997) Is the list server working? (1998) Fwd: Problems with Webcatalog Plug-in (1997) SiteGaurd file Cache vs webcatalog cache (1997) WebCat 3? (2000) Bugs? What Bugs? was:Spawning Holdup? (2000) Comments in db? (1997) [lineitems] and [writefile] (1998) Expires header (1999) New public beta available (1997) Help! WebCat2 bug (1997) Unique SKU Numbers (2000) Making WebCatalog run as www (2006)