I am not getting this. I need a nudge in the right direction.
I want to do this query:
select distinct sk.sid from searchkeys sk, searchwords sw
where sw.searchword="somesearchword"
sw.sid = sk.sid
sk.state="somestate";
table searchkeys:
sid <-- unique PK
state
table searchwords:
swid <-- unique PK I wish OJB didn't require
sid <-- sid in searchkey table
searchword
searchkeys and searchwords having a 1:n relationship.
Right now I both tables mapped according to their characteristics which I have
done many times before. In the past I have always wanted the primary keys and
full records.
Here I don't want the full records or mapping, but just a collection of the
unique sid. I would prefer not to get the full records and I only require this
for read and not write. Imagine I am doing a keyword search and I just want
to know which services match the search criteria.
Can anybody nudge me in the right direction? Would be great to get past this
problem. I am trying to inprove the searching on my live OJB used site by
including parts of the Lucene project, but need to be able to do this for it to
work.
Thanks lots.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
