Nope. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baz Sent: Friday, February 10, 2006 1:02 PM To: [email protected] Subject: Reactor For CF sortByFieldList
Hi, Can you specify asc/desc for sortByFieldList when doing getAll() or getByField()? Baz -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Blackwell Sent: Friday, February 10, 2006 1:07 PM 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
