I need to return every 5th row(customers review only every nth entry) like the following but along with a whole bunch of property restrictions that I already have working...

http://www.iknowkungfoo.com/blog/index. ... Nth-Record

I was thinking I need to do this with Projections or something as it basically adds a temporary row column to be used in a later restriction...anyone know how to do this?

I would hate to revert back to putting the sql string together especially as it could open us up to sql injection attacks as some of these may come from url params later.

thanks,
Dean

hmmm, I guess that is not really a join, but I wasn't thinking yesterday. It is really a subselect in the from clause to narrow the results of the table generated by the first select statement. Is there a way to do that in criteria api?

Is there extension points in the api?