Re: Searching for words equal to A or equal to B
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 22490
interpreted = N
texte = >>>>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-ed > >You could provide several text fields on the form, and group them together >so they all search the same db field -- thus allowing your visitors to >enter a single 'exact match' string into each of those text fields, or as >many as they need. Then use eq as your comparison operator -- without >requiring the field in a search (do not use rq) ... > >If you do this, the visitor could enter Rover into one of the text >fields, and the search would find all the db fields exactly matching >Rover -- without finding Land Rover. And if the visitor used a second >text field to enter Mercedes Benz, then the results would retrieve all >records having exactly Rover OR exactly Mercedes Benz -- but nothing >else. This is what you want, right? >This is what I want, when I tried this it works fine, I thought it was cracked.....BUT what I failed to say in my initial post, because I was trying to keep it as simple as possible, is that I am also trying to narrow my search by other criteria too, bodystyle, transmission and fueltype. All of which may have more than one option selected.My full search which has the Rover problem was as follows (all on one line of course)[search db=db/cardata.db &rnotrpricedatarq=[zpricel] [zpriceh] &wobodystyledatarq=[FormVariables name=bodystyle][url][value][/url],[/FormVariables] &wofueltypedatarq=[FormVariables name=fueltype][value],[/FormVariables] &wotransmissiondatarq=[FormVariables name=transmission][value],[/FormVariables] &womanufacturerdatarq=[FormVariables name=manufacturer][value],[/FormVariables] ]I tried group searches. With two different group-searches in one search string the results are all fields that match group1 AND all fields that match group2, and not what I require which is all fields that match IN BOTH group1 and group2.By the way all my choices are by checkbox so the criteria are fixed.Paul Willis
Associated Messages, from the most recent to the oldest:
>>>>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-ed > >You could provide several text fields on the form, and group them together >so they all search the same db field -- thus allowing your visitors to >enter a single 'exact match' string into each of those text fields, or as >many as they need. Then use eq as your comparison operator -- without >requiring the field in a search (do not use rq) ... > >If you do this, the visitor could enter Rover into one of the text >fields, and the search would find all the db fields exactly matching >Rover -- without finding Land Rover. And if the visitor used a second >text field to enter Mercedes Benz, then the results would retrieve all >records having exactly Rover OR exactly Mercedes Benz -- but nothing >else. This is what you want, right? >This is what I want, when I tried this it works fine, I thought it was cracked.....BUT what I failed to say in my initial post, because I was trying to keep it as simple as possible, is that I am also trying to narrow my search by other criteria too, bodystyle, transmission and fueltype. All of which may have more than one option selected.My full search which has the Rover problem was as follows (all on one line of course)[search db=db/cardata.db &rnotrpricedatarq=[zpricel] [zpriceh] &wobodystyledatarq=[FormVariables name=bodystyle]
[url][value][/url],[/FormVariables] &wofueltypedatarq=[FormVariables name=fueltype][value],[/FormVariables] &wotransmissiondatarq=[FormVariables name=transmission][value],[/FormVariables] &womanufacturerdatarq=[FormVariables name=manufacturer][value],[/FormVariables] ]I tried group searches. With two different group-searches in one search string the results are all fields that match group1 AND all fields that match group2, and not what I require which is all fields that match IN BOTH group1 and group2.By the way all my choices are by checkbox so the criteria are fixed.Paul Willis
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:
Multiple Unique SKUs (2000)
Smart caching problems with 2.1b3? (1997)
UPPERCASE (1997)
Execute Applescript (1997)
bug in [SendMail] (1997)
Resume Catalog ? (1997)
Multiple prices (1997)
WebCatalog Use Question (1997)
Reversed words (1997)
Updating checkboxes made easy !!! (1998)
Sort & Shownext (1999)
auto-stripping of spaces (1997)
[convertchars] problem... (2000)
Not really WebCat (1997)
(1997)
Re:2nd WebCatalog2 Feature Request (1996)
unable to run webcatalog locally (1998)
Newbie questions (1999)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
A multi-processor savvy WebCatalog? (1997)