I don't know how to do that with criteria API (though there may be a way) but to give you a few alternates, you could rewrite this query as a join to remove the subquery problem and then it is pretty standard. You could also directly submit the SQL you have entered which I tend to do if mapping/criteria gets too complicated and it is a simple query.
On Sep 21, 7:29 am, paper1337 <[email protected]> wrote: > To follow up on this, the only part that I have not figured out how to > do is extracting the SQL string that would be generated if I were to > call the List() method on an object implementing ICriteria. I would > like to retrieve this as a string for use inside an ORDER BY clause. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
