Use SqlProjection and ordr accordingly. Tuna Toksöz http://tunatoksoz.com http://turkiyealt.net http://twitter.com/tehlike
Typos included to enhance the readers attention! On Tue, Mar 10, 2009 at 6:02 PM, TigerShark <[email protected]>wrote: > > Just found an issue on Hibernate about the exact same problem: > > http://opensource.atlassian.com/projects/hibernate/browse/HHH-465 > > http://forum.hibernate.org/viewtopic.php?p=2241474&sid=e5e11103a4923c46270e291644bfdb6b > > > On 10 Mar., 16:34, Fabio Maulo <[email protected]> wrote: > > which is the SQL ? > > > > 2009/3/10 TigerShark <[email protected]> > > > > > > > > > > > > > Hi there > > > > > I have a small question, I hope someone can help me answer. > > > > > I have a class consisting of several properties, where some are > > > nullable DateTime types. > > > > > When I am sorting by these properties, it does as expected, according > > > to the direction of the order, however, when I am sorting ascending, > > > the rows with nulls are at top. This is default behavior in most DB's > > > I guess, but now to my question. > > > > > How to I make the rows with nulls stay at the bottom? I have been able > > > to do this in pure SQL, but I can't seem to find any way to override > > > the default sorting behavior of NHibernate... > > > > -- > > Fabio Maulo > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
