Hi Plen,
Try
IQuery iq = querySession.CreateQuery("select src from RptDocumentBase src
where
src.RptDocumentCore in (select srcc.DocCoreId from RptDocumentCore
srcc where contains(srcc.Body, 'florida')>0")
this should return a List of RptocumentBase object.
On Wed, Aug 17, 2011 at 1:18 AM, PLen <[email protected]> wrote:
> I may have simplified my query too much in the above question. What I
> really have is a query that looks like:
>
> IQuery iq = querySession.CreateQuery("from RptDocumentBase src where
> src.RptDocumentCore in (select srcc.DocCoreId from RptDocumentCore
> srcc where contains(srcc.Body, 'florida')>0")
>
> So there is actually a join of two tables in the query (I want
> RptDocumentBase objects back based on a 'contains' query in the
> RptDocumentCore table).
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
Jack Xu
Best Regards
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
