IT will solve, but i wonder why you don't have a reference to Institution in FIServiceLocation but only have the id of institution?
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Mon, Sep 21, 2009 at 12:39 PM, paper1337 <[email protected]>wrote: > > Upgrading to the latest version of NHibernate may be an option if that > would solve my problem in a relatively staightforward manner. Do you > know how to do this in NHibernate 2.1.0 GA? > > On Sep 21, 9:39 am, Tuna Toksoz <[email protected]> wrote: > > I think this is a feature added in 2.0+ > > > > Tuna Toksöz > > Eternal sunshine of the open source mind. > > > > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > > > On Thu, Sep 17, 2009 at 4:57 PM, paper1337 <[email protected]> > wrote: > > > > > Using the Criteria API, I want to create a query that generates SQL > > > like: > > > > > SELECT BranchID > > > > > FROM FIServiceLocation > > > > > ORDER BY (SELECT InstitutionName FROM Institution WHERE > > > Institution.InstitutionID=FIServiceLocation.InstitutionID) > > > > > This is just an example to reflect my requirements, but hopefully it > > > gets my point across. Effectively I want to order my results by the > > > results of a subquery. If anyone has any advice on how to go about > > > this (already tried banging my head against the wall...does not seem > > > to be working), it would be much appreciated. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
