Re: Sorting & SQL-Database

2006-07-08 Thread George Abraham
Dominik, Sorry I saw this a little late, but I asked a similar question back in Dec 2005 and Jeff Rodenburg gave me some splendid help which we are implementing even now. Here is the gist of his solution. - Include the Lucene Doc's score (or sequential order, as an int) with the list of id values

lucene and database searching, keeping score

2005-12-02 Thread George Abraham
All, I have created a Lucene index from data in a SQL Server db. When I conduct a Lucene search, I get back in the hits the primary key (WorkID) and the scores associated with the hits. Then using the list of WorkIDs, I query the database for the other associated information of the assets associate

Re: Lucene vs SQL database

2005-09-29 Thread George Abraham
Eugene, You could grab all the fields for a record in a SQL database, mash it all together and transfer it into one indexing field in Lucene. Use some scripting tools (or even JDBC and Java) to do this. However if you are asking if Lucene can go and look over a SQL database and return results, that

Re: querying multiple fields

2005-06-22 Thread George Abraham
Erik, That worked like a charm. It seems to me that reading up on the different analyzers would solve a lot of questions in my mind. Unfortunately your book has not arrived yet from Amazon. Aarrgh! Thanks a ton! George > Your analyzer is eating the ImageExistsBit:1 because "1" returns no > tokens

Re: querying multiple fields

2005-06-22 Thread George Abraham
:\"visnu temple\" ImageExistsBit:1". The .toString() for this query is SearchTerms:"visnu temple" Thanks, George On 6/22/05, Otis Gospodnetic <[EMAIL PROTECTED]> wrote: > George, > > You can use MultiFieldQueryParser instead of QueryParser. > > Otis &

querying multiple fields

2005-06-22 Thread George Abraham
All, Forgive me for the basic question. When you are querying multiple fields using QueryParser, what is the exact code? I tried QueryParser.parse(queryString, "SearchTerms", analyzer) where queryString was "SearchTerms:visnu temple ImageExistsBit:1", SearchTerms and ImageExistsBit being the two f

indexing values which might be null

2005-06-21 Thread George Abraham
Hi, I am using Lucene to index database content. I have two questions: 1. Along with some of the fields that I want indexed, there are some fields that I want stored (not indexed) in the index so as to return with hits. However I also want to be able to sort a search result using these non-indexed