2. ASPRunnerPro General questions
  3. Searching for multiple keywords in multiple fields
This topic is locked

Searching for multiple keywords in multiple fields

 		5/9/2008 9:50:33 AM
ASPRunnerPro General questions
S
 Suhada author

Dear all,

I have a requirment to search for multiple keywords in multiple fields.

For instance I might want to type "FORD WHEEL" into a search textbox and I want a

search in perhaps 5 different fields for both those terms.

Each keyword can exist in any field but all keywords must be present in at least one field.

Any thought would be helpful.

Thanks

Suhada
Sergey Kornilov admin 5/9/2008

Suhada,
for search like this I recommend to use database that supports full-text search (SQL Server or MySQL).

You'll need to implement BeforeSQLQuery event to override default query ASPRunnerPro builds for you.