title: Order By Rand by Time (HQL)
body: <p>I'm developing a web application using asp.net Mvc 2 and NHibernate, and I'm paging data (products in a category) in my page, but this data are random, so, I'm using a HQL statement link this:</p>
  
  <pre><code>string hql = "from Product p where p.Category.Id=:IdCategory order by rand()";
  </code></pre>
  
  <p>It's working fine, but when I page, sometimes the same product appears in the first, second, etc... pages because it's order by rand().</p>
  
  <p>Is there any way to make a random order by fixed by period (time internal) ? Or any solution ?</p>