I looked through the archive a bit and found some Q & A's regarding this but I didn't see anything definitive so I thought I'd ask again...
Basically, I have a web page that can search through a database table across multiple servers. So imagine that there are 100 different databases spread across a number of servers but the schema is same. I created an index with fields specific to each row in a particular table such as NAME, TYPE, COMPANY, etc. in addition to SERVER, DATABASE so I can capture where they are from. Ultimately, what I want is a single HTML input field that can capture a query expression and instantiate a searcher and return a result set. This querystring should be in any number of forms: Ex) John Doe ABC Company (which would search for each word OR'ed in all of the fields) "John Doe" And "ABC Company" (which would search for "John Doe" AND'ed with "ABC Company" in all of the fields) NAME:"John Doe" COMPANY:"ABC Company" (which would search for results where either NAME contains "John Doe" OR COMPANY contains "ABC Company") NAME:"John Doe" And COMPANY:"ABC Company" (which would search in each field but must match both fields) +NAME:"John Doe" +COMPANY:"ABC Company" (which I understand is same as the previous line - if not please correct me) So I am wondering if a single instance of Query and MultiFieldQueryParser can do this. Do I need any other special processing? Here's what I have right now (C#): string[] searchFields = new string[] { "SERVER", "DATABASE", "NAME", "COMPANY", "TYPE" }; MultiFieldQueryParser parser = new MultiFieldQueryParser(searchFields, new StandardAnalyzer()); parser.SetDefaultOperator(QueryParser.Operator.OR); Query query = parser.Parse(querystring); Then I pass 'query' into MultiSearcher. Well, it's not returning the results as I expect. Can some show me what I need to change? Thanks Jiho Han Senior Software Engineer Infinity Info Systems The Sales Technology Experts Tel: 212.563.4400 x6375 Fax: 212.760.0540 [EMAIL PROTECTED] www.infinityinfo.com <http://www.infinityinfo.com/> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]