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