Re: Multiple Search Fields

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18696
interpreted = N
texte = You need to add rq to the end of your search context for each field that is required.>I'm trying to make a search where there are multiple fields that can be >searched. >I used the default search template that is made by webcat's database helper , >but that's not doing what I want it to do. here's what I got >I have a few fields > Area : > # of Rooms : > price : >I want to make it where a user can search the fields and get just what they >are looking for. >If one field is searched at a time it works fine , but when all search >together that's where I >have my problem, say my area was New Orleans , # of Rooms is 4 , and price >is 122000, >the search would find all items in the catalog with any of those matches , >I've tried variations >of the string match, and , or options but it still pulls up all. > >I want to make it where a user could search for New Orleans, 4 bedrooms , >122000 and have >it just get the items that are meant to be found > >Is this possible???? Associated Messages, from the most recent to the oldest:

    
  1. Re: Multiple Search Fields (talk 1998)
  2. Re: Multiple Search Fields (talk 1998)
  3. Re: Multiple Search Fields (Dave MacLeay 1998)
  4. Multiple Search Fields (talk 1998)
  5. Re: Multiple Search Fields (Marty Schmid 1998)
You need to add rq to the end of your search context for each field that is required.>I'm trying to make a search where there are multiple fields that can be >searched. >I used the default search template that is made by webcat's database helper , >but that's not doing what I want it to do. here's what I got >I have a few fields > Area : > # of Rooms : > price : >I want to make it where a user can search the fields and get just what they >are looking for. >If one field is searched at a time it works fine , but when all search >together that's where I >have my problem, say my area was New Orleans , # of Rooms is 4 , and price >is 122000, >the search would find all items in the catalog with any of those matches , >I've tried variations >of the string match, and , or options but it still pulls up all. > >I want to make it where a user could search for New Orleans, 4 bedrooms , >122000 and have >it just get the items that are meant to be found > >Is this possible???? Marty Schmid

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:

color and size options (1997) [Sum] function? (1997) Problems with upload / WebCat (1998) Physical Security for WebCatalog Directories (1997) Webcat deletes last line from Excel-saved text db (2004) Sales Tax db (1998) Cart ID (1999) Rename folder under WC3 (2000) WebDNA 4.5.1 Now Available (2003) [shownext max=?] armed (1997) [WebDNA] OT - does anyone know how to get Fetch/BBedit to (2009) WebTen Memory Error with Plug-In (1998) Multiple Ad databases? (1997) RE: pricing continued (1998) NetSplat and WebCat2 (1997) Multi Colonns (1998) Lots of bounce errors (2007) do NOT process webdna tags (2005) Project 2 (1998) NT Manual (1997)