navcan
Posts: 61
|
| Posted: 10/05/2004, 6:48 PM |
|
How can I create a search form having and/or criteria. In my search form I have four fields,
1. Customer Name
2. Dropdown list having two items AND & OR (for criteria)
3. Customer City
4. Customer Country
Now I would like to search as
Search by Customer Name = “s_name” AND Customer City = “s_city” WHERE Customer Country = “s_country”
Also using the same search form I would like to search as
Search by Customer Name = “s_name” OR Customer City = “s_city” WHERE Customer Country = “s_country”
S_name, s_city and s_country are the parameters
Could anybody please advise how to create a search form where user can have the flexibility to create his or her own criteria on the fly.
I am using Access database and ASP with CCS. Thanks
|
 |
 |
navcan
Posts: 61
|
| Posted: 10/06/2004, 6:17 PM |
|
Hello Peterr, any suggestions???
|
|
|
|
cobom
Posts: 55
|
| Posted: 10/06/2004, 6:33 PM |
|
Just a beginner in this myself - but it sounds like you do not need the 'third' AND / OR choice - maybe just a way to assign a relevance to the search. If name, city , country all match they will sort to the top, if only 2 match then further down the list, etc.
You see this type of weighting in a lot of searches - maybe a forum visitor can expand??
_________________
cmckinney@searay.com
Will program for a Sea Ray 680 SS ;} |
|
|
|
peterr
Posts: 5971
|
| Posted: 10/07/2004, 3:47 AM |
|
Sorry, I don't have specific ideas. Though I would probably play with dynamically changing the datasource (Where statement) in the events, as shown in the Examples & Programming section of the documentation.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
