Anonymous keys R
On 11/22/04 8:46 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
