numero = 11096
interpreted = N
texte = Let's suppose I have several different Name fields in my database, and I want my users to ba able to enter data into a single text field to search all those Name fields at once ...In my search form I can put something like this:then further on down, I can put:Okay so far ... but how does this actually do the search? Does it only retrieve records that have the word 'mountains' in ALL of the three fields in the group? Or does it retrieve all the records that have the word 'mountain' in ANY of those three fields?What I WANT it to do is retrieve all the records with the word 'mountain' in ANY of the three fields ... but I'm not sure if this is all there is to it. I couldn't seem to find the examples for searching using groups in the html docs, so either I'm not looking in the right place or else there's nothing there. I thought I had seen it before, I just don't know where ... :)Sincerely, Ken Grome ..... ken@iav.com
Associated Messages, from the most recent to the oldest:
Grouping search fields, etc. (Kenneth Grome 1997)
Let's suppose I have several different Name fields in my database, and I want my users to ba able to enter data into a single text field to search all those Name fields at once ...In my search form I can put something like this:then further on down, I can put:Okay so far ... but how does this actually do the search? Does it only retrieve records that have the word 'mountains' in ALL of the three fields in the group? Or does it retrieve all the records that have the word 'mountain' in ANY of those three fields?What I WANT it to do is retrieve all the records with the word 'mountain' in ANY of the three fields ... but I'm not sure if this is all there is to it. I couldn't seem to find the examples for searching using groups in the html docs, so either I'm not looking in the right place or else there's nothing there. I thought I had seen it before, I just don't know where ... :)Sincerely, Ken Grome ..... ken@iav.com
Kenneth Grome
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...