>From looking at the query debug output it looks like setMaxRows() function sets the maxrows attribute of the <cfquery> tag, as I don't see LIMIT in the sql.
When displaying large paginated recordsets i like to use the power of MySQL's LIMIT clause and provide an offset so I only get back the rows I will be displaying, like... SELECT * FROM tblName LIMIT 10 OFFSET 20 I don't know whether this works in other DB's. So is there anyway to implement this in Reactor? Seems to me that the query object would need a setOffset() method, but that might break in dbs other than mysql. If this is "application functionality that is needed by the developer that may seem, to the developer, like it should be a job of the framework itself" then feel free to shoot me down ;) At the moment I'm still trying to get my head around Reactor so working out where it should end and my application starts is a little blurry atm. Chris
