Beware that this will cause you troubles again when upgrading to the future 3.2.1 or later. Might want to track those workarounds somehow.
/Oskar 2011/12/5 Visar Uruqi <[email protected]>: > Hi > > I had a similiar problem. I'm using NH 3.2 and indeed it returns 0 > rows. > > before > ===== > var lista = session.QueryOver<Case> > .Take(PageSize) > .Skip(page * PageSize) > .List<Case>(); > > NO RESULTS....0 RECORDS > > > I looked at the NHprof profiler and analyzed the select statement that > was made to oracle... > and I solved the problem with this TWEAK. > > var lista = session.QueryOver<Case> > .Take(page * PageSize + PageSize) > .Skip(page * PageSize) > .List<Case>(); > > IF YOU LOOK TO THE QUERY IN NHPROF OR TO THE LOG FILES THEN YOU WILL > SEE WHAT I MEAN. > > > > > -- > 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. > -- 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.
