Context: searching multiple text fields in a single query

From: Tammie Nelson-Stringer <tammienelson_at_mindspring.com>
Date: Wed, 6 Jan 1999 14:09:37 -0500
Message-ID: <770c9v$fjg$1@camel18.mindspring.com>

Hello:

I plan to use Context in my application, currently in the design stage. Trying to determine which method is most appropriate. A two part question follows:

Part I:

I would like to use the in-memory method; it seems as if it must be the most efficient approach, and CTX_QUERY.FETCH_HIT would be convenient for my application (web-based, with an incrementally displayed result list page).

However, I'd like to be able to allow the user to search multiple text fields in a single query. Is one-step the only approach that will allow multiple text fields in a single query?

Part II:

There are two types of multiple text queries that I can envision. One is to allow the user to type in a text string for two or more text fields. Obviously this would involve querying multiple policies.

A second type is to allow the user to type a single string and then search that same string against multiple fields. In other text search engines I can do this easily. Can this be done easily with ConText or will I have to create a policy for each text field and then manufacture a one-step query with multiple CONTAIN function calls in the WHERE clause?

Many thanks!
Tammie

---

Tammie Nelson-Stringer
Domain technologies
t.nelson-stringer_at_domain-tech.com Received on Wed Jan 06 1999 - 13:09:37 CST