Well, as I'm no expert I don't know either, but I thought the dialect implementation had something to do with the way the different db's handled order by's. But after some research I can see that theres nothing about orders in the dialect base class, so I guess it's a sql standard.
However, in the links I provided, I read that "nulls first" was sql-99? On 10 Mar., 18:14, Tuna Toksoz <[email protected]> wrote: > I don't know how would you do that with dialect. > > Tuna > Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp://twitter.com/tehlike > > Typos included to enhance the readers attention! > > On Tue, Mar 10, 2009 at 7:08 PM, TigerShark <[email protected]>wrote: > > > > > Hmm, I see. Is that the only way? I was hoping for the dialect to > > handle it for me...? > > > On 10 Mar., 17:22, Tuna Toksoz <[email protected]> wrote: > > > Use SqlProjection and ordr accordingly. > > > > Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp:// > > 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=e5e11103a4923c. > > .. > > > > > 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 -~----------~----~----~----~------~----~------~--~---
