Re: Oracle Text and Java

RTM on SCORE() and its meaning. Also, RTM on CTX_DOC package - it has everything you need to markup and highlight searched terms. And I am not aware of any way to find exact count of the search term in the document.

--
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"cot_r" <bvanespen_at_yahoo.com> wrote in message
news:Fptb8.145648$rt4.13415_at_afrodite.telenet-ops.be...


> Hi,

>

> I stored files( pdf,word) in blob column. I created index (INSO_FILTER) and


> i would like to query the files.

> ...

> String sword="test";

> String query = "Select COMPID,CREATED,NAME,CVNUMBER from COMPANYCV" + "

> where contains(CV,' "+sword+" ') > 0 " ;

> System.out.println(query);

> ResultSet rs = stmt.executeQuery(query);

> ...

> works fine i get the compid,date,number and filename of the stored file in

> the blob column. This info is displayed als a link(url). ie. <A

> HREF="ShowCv.jsp?NAME=doc1.pdf...... So when the user clicks on it, the

> appropriate program opens (word,acrobat reader) and the content of the file

> is shown.

>

> But i also want to know how many times the word "test" is found in each of

> the documents? How can i do this in java (jsp)?

>

> And i want to highlight to word that is searched for in the document? Any

> help on doing this ( examples)? The doc should open in the

> browswer( html -version) and words

> should be highlighted.

>

> plz help!

>

> ps.

>

> if i use:

> select score(1),NAME,COMPID from COMPANYCV where contains(CV, 'BLOB',1 ) > 0

> order by score(1) desc

>

> i get:

> 100,Test2.doc,4

> 39,Test1.doc,5

>

> the score is 39 with Test1.doc! But the word blob is not present in that

> document. What does the  score realy mean?

>

> thx

>

>

>