Searching for words equal to A or equal to B

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22273
interpreted = N
texte = HiI am doing a search of products by price which works fine and now I want to narrow the search based on user selections of manufacturers from a list.It is required that the results match only any of the maufacturers selected all others being ignored.I have this working fine with a womanufacturerdatarq=manufacturer1,manufacturer2,manufacturer3 etc. in my search criteria along with my prices, but the problem occurs when I have manufacturers where part of a name is common.In this case cars, when Rover is selected it also brings back results for Land Rover and visa versa. I have put [url] in my initial form but for WO searches this doesn't seem to work.The problem here is WO search is not exact enough, it finds all my search words in the manufacturer field, I need EQ or BW searches of multiple manufacturers on the same field but also I need to have them RQ-edI need a tag like WEQO, unless anyone can suggest another way of doing this?Paul Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching for words equal to A or equal to B (Paul Willis 1999)
  2. Re: Searching for words equal to A or equal to B (Kenneth Grome 1999)
  3. Re: Searching for words equal to A or equal to B (Paul Willis 1999)
  4. Re: Searching for words equal to A or equal to B (Peter Ostry 1999)
  5. Searching for words equal to A or equal to B (Paul Willis 1999)
HiI am doing a search of products by price which works fine and now I want to narrow the search based on user selections of manufacturers from a list.It is required that the results match only any of the maufacturers selected all others being ignored.I have this working fine with a womanufacturerdatarq=manufacturer1,manufacturer2,manufacturer3 etc. in my search criteria along with my prices, but the problem occurs when I have manufacturers where part of a name is common.In this case cars, when Rover is selected it also brings back results for Land Rover and visa versa. I have put [url] in my initial form but for WO searches this doesn't seem to work.The problem here is WO search is not exact enough, it finds all my search words in the manufacturer field, I need EQ or BW searches of multiple manufacturers on the same field but also I need to have them RQ-edI need a tag like WEQO, unless anyone can suggest another way of doing this?Paul Paul Willis

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:

Generating Report Totals (1997) CommandSecurity? (1997) matching shipto and others (1998) HELP WITH DATES (1997) japanese characters (1997) 2.0 Info (1997) More questions about serial number dishing (1997) [Announce]: Web server security and password protection (1997) DDEConnect not working (2006) Check Boxes (2000) $adminput doesn't allow [include] files (1997) WebCat2 several catalogs? (1997) RE: Clearing orders and database help! (1997) price carry over (1997) How do I access a shopping cart once it had been moved (2000) Include vs. lookup? (1998) WebCat2: multiple currency support (1997) 404 error -- but wc code executes... (2001) formula.db, adding option prices (1997) Open Databases on Restart (1999)