Skip to main content.
home | support | download

Back to List Archive

Re: forcing meta values when indexing

From: Bill Moseley <moseley(at)not-real.hank.org>
Date: Sun Sep 24 2006 - 17:07:06 GMT
On Sun, Sep 24, 2006 at 01:00:43PM -0400, Philippe A. wrote:
> >
> >Not sure I follow.  You want to do a full-text search on the resume
> >and then look up the related candidate in the database for each
> >search result?
> 
> 
> Yes that's it.
> 
>    select * from candidate where resume_file = ?
> >
> 
> I wanted to use the cand_id badly. I'll just concatenate it in the filename
> and work from there.

Why not use the resume_file column?

    create index resume_file_index on resume (resume_file)

> My initial question isn't very important anymore, but I'd like to know
> anyway: is there a way to force abritraty metas in the index? I mean, by cfg
> or command line arg? I'm not fond of playing with a doc structure (on the
> fly or not).

Well, if you want to use the ID it has to get into the doc somehow to
be indexed.

Why not put the resumes into the database so you don't have this
linkage problem between the database and the resume?

-- 
Bill Moseley
moseley@hank.org

Unsubscribe from or help with the swish-e list: 
   http://swish-e.org/Discussion/

Help with Swish-e:
   http://swish-e.org/current/docs
   swish-e@sunsite.berkeley.edu
Received on Sun Sep 24 10:07:06 2006