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 tonarrow the search based on user selections of manufacturers from a list.It is required that the results match only any of the maufacturers selectedall others being ignored.I have this working fine with awomanufacturerdatarq=manufacturer1,manufacturer2,manufacturer3 etc. in mysearch criteria along with my prices, but the problem occurs when I havemanufacturers where part of a name is common.In this case cars, when Rover is selected it also brings back results forLand Rover and visa versa. I have put [url] in my initial form but for WOsearches this doesn't seem to work.The problem here is WO search is not exact enough, it finds all my searchwords in the manufacturer field, I need EQ or BW searches of multiplemanufacturers 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:
HiI am doing a search of products by price which works fine and now I want tonarrow the search based on user selections of manufacturers from a list.It is required that the results match only any of the maufacturers selectedall others being ignored.I have this working fine with awomanufacturerdatarq=manufacturer1,manufacturer2,manufacturer3 etc. in mysearch criteria along with my prices, but the problem occurs when I havemanufacturers where part of a name is common.In this case cars, when Rover is selected it also brings back results forLand Rover and visa versa. I have put
[url] in my initial form but for WOsearches this doesn't seem to work.The problem here is WO search is not exact enough, it finds all my searchwords in the manufacturer field, I need EQ or BW searches of multiplemanufacturers 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)