Tipu
|
| Posted: 06/26/2002, 2:35 AM |
|
There are 2parts of my questions
1--
I have a search box which look in fields for word typed in the box and then show the result on seprate page. but if the words are not together it never finds the record.
For Example i am looking for a record(field event description) and type in Tipu event.
it show me a page with no record found but if i do a search seprate for both word it show me all the pages which contain tipu or event, is it possible to make this search for both words even if they are not after eachother.
2nd question.
can i do a boolean search for same example . Like if i wanna list all the events which have words tipu and microsoft .
Thank you so much in Adv.
Tipu
|
|
|
 |
Freeman Kusek
|
| Posted: 06/27/2002, 1:26 AM |
|
1. You can customize the search by using an appropriate SQL operator to match the field value agains the search criteria. = gives an exact match, Like %..% gives the records which contain the search criteria, etc. There are a numbe of these operators and a good SQL reference would have information about their use.
In CCS, when you specify a where parameter for form, you can select one of these operators.
2. I would use two fields to submit each value then specify each as an input parameter. I suppose the 'neat' way would be having both values in one field but that would entail writing code to parse the values and create an appropriate SQL for them.
|
|
|
|
|
