Multiple Search Fields

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18699
interpreted = N
texte = 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 foundIs 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)
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 foundIs this possible???? talk

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:

Sku numbers (1997) RE: Formulas.db + Users.db (1997) RequiredFields template (1997) RAM variables (1997) syntax question, not in online refernce (1997) Re1000001: Setting up shop (1997) Adding to Cart (2004) really wierd browser truncating (1997) WebTEN vs webSTAR (1998) WebCat2 several catalogs? (1997) Help! WebCat2 bug (1997) RequiredFields template (1997) More on the email templates (1997) SiteEdit NewFile.html ? (1997) Help name our technology! (1997) form data submission gets truncated (1997) Version 2.0 and 1.6 simultaneous (1997) Multiple Ad databases? (1997) PCS Frames (1997) A dynamic database. (1997)