Depending on what you are trying to search. Let's say your table A is the table with the "real" content, and B and C are your lookup table.
You should build one index in this case. And select A's content together with B and C's lookup value into the documents. I strongly recommend you take a look at DBSight. You can create the index or several different index super easily. And you can test with different index structure with out any coding. BTW: It's not really user friendly to let users choose a drop-down. You can try DBSight's narrowBy feature. Like the one you will see here, http://search.dbsight.com Chris Lu --------------------------------------- Full-Text Lucene Search on Any Databases http://www.dbsight.net Faster to Setup than reading marketing materials! On 4/13/06, Ananth T. Sarathy <[EMAIL PROTECTED]> wrote: > No we do have drop downs selects that would allow for the substitution, but > we also have a free text fields to allow the user to search. That solution > would I think work for the DB query replacement, but you would need a > regular non underscored field to allow for free text. > > On 4/13/06, Erick Erickson <[EMAIL PROTECTED]> wrote: > > > > Well, that's a problem you must already be solving. Somewhere, you have to > > construct your DB query and recognize what constitutes a "term". From your > > previous mail, you imply you can construct this query... > > > > select count(distinct Crew_ID) from Crew_TItles where Title="Producer" > > > > Where did you get "Producer"? Presumably you have some rules for turning > > the > > form-entered data into a SQL query, I assume just the contents of the > > entry > > box. So I don't see why it's at all hard to replace all spaces with > > underscores and send the result term to Lucene. Whatever your process, you > > have to decide what user entries you use for Title="blah". When you've > > isolated the "blah", just do the substitution. > > > > Or I completely misunderstand your problem, which is entirely possible. > > > > Best > > Erick > > > > > > > -- > Ananth T Sarathy > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
