Grouping search fields, etc.

This WebDNA talk-list message is from

1997


It keeps the original formatting.
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:

    
  1. 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

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:

[WebDNA] Is there a good file upload script available these days? (2009) Include a big block of text (1997) Information on Vieworders.tpl (1998) Date fun with MySQL (2004) WebCat2b15MacPlugin - showing [math] (1997) Cancel Subscription (1996) Problems passing [SKU] with $Replace in 2.0 (1997) SmithMicro Help! -- Can't access WebCatalog Admin! (2001) WCS Newbie question (1997) WCf2 and nested tags (1997) A question on sub-categories (1997) PCS Frames (1997) Just Testing (1997) WebDNA 4.5.1 Now Available (2003) [WriteFile] problems (1997) protect tag on NT IIS (1997) Database append/replace (2004) [/application] error? (1997) Dealing with da back button (1999) Newbie Help (2003)