Anybody know to do page a QoQ like MySQL's LIMIT?

You could easily create your own startRow/endRow functionality. Let us call your query myQuery. You could then proceed as follows:

<cfset rowCount = arrayNew(1)>

<!--- Store query row numbers in array --->

<cfloop from="1" to="#myQuery.recordCount#" index="n">

<cfset rowCount = n>

</cfloop>

<!--- Add column containing row numbers to query --->

<cfset queryAddColumn(myQuery, "rowNumber", "integer", rowCount)>

<!--- Example --->

<cfset startRow = 5>

<cfset endRow = 11>

<cfquery name="getSubset" dbtype="query">

select *

from myQuery

where rowNumber between #startRow# and #endRow#

</cfquery>

<cfdump var="#getSubset#">

You just need to use maxrows on the <cfquery> tag. There's nothing in the QoQ SQL implementation to do row-limiting.

This is not documented on the QoQ page:

CF9: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html

CF10: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html

--

Adam