Into your log4net configuration you can paste this to see what actually NH
is generating

...
<logger name="NHibernate.SQL">
     <level value="DEBUG" />
</logger>
...

On Mon, Mar 16, 2009 at 11:01 PM, Craig van Nieuwkerk <[email protected]>wrote:

>
> I am using nHibernate and trying to implement some paging. If I run this
> code
>
>    IList list = session.CreateQuery("FROM Author").List();
>
> it returns 8 records. If I run this code though
>
>    IList list = session.CreateQuery("FROM Author")
>        .SetFirstResult(1).SetMaxResults(5).List();
>
> it returns 0 records. When I look at the SQL generated I can't see
> that there is any paging logic.
>
> What is the most likely errors with this?
>
>
> Craig
>
> >
>
>


-- 
Dario Quintana
http://darioquintana.com.ar

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to