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 = 22423
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-edYou 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?Also, if the db fields you're searching have a limited number of values, you might consider using popup selection fields instead of text fields. Then your visitors can make a quick selection without the possibility of typing a mis-spelled entry and getting zero matches ...Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:

Re: Searching for words equal to A or equal to B (Paul Willis 1999)
Re: Searching for words equal to A or equal to B (Kenneth Grome 1999)
Re: Searching for words equal to A or equal to B (Paul Willis 1999)
Re: Searching for words equal to A or equal to B (Peter Ostry 1999)
Searching for words equal to A or equal to B (Paul Willis 1999)

>>>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-edYou 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?Also, if the db fields you're searching have a limited number of values, you might consider using popup selection fields instead of text fields. Then your visitors can make a quick selection without the possibility of typing a mis-spelled entry and getting zero matches ...Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Kenneth Grome

DOWNLOAD WEBDNA NOW!

Re: Searching for words equal to A or equal to B

1999

Top Articles:

Related Readings: