Unfortunately, the limit clause is not cross DBMS. (Oh how I wish it was.)
Sorry! Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Lantz Sent: Friday, February 10, 2006 1:01 PM To: [email protected] Subject: RE: Reactor For CF query.setMaxRows() I have to agree that some sort of functionality like that would be great for pagination, and, short of writing your own query and bypassing Reactor, I don't see how this could be done within the framework as it now stands. I do believe that LIMIT/OFFSET is mysql specific, though... Michael -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Friday, February 10, 2006 11:07 AM To: [email protected] Subject: Reactor For CF query.setMaxRows() >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
