CFLib.org – Common Function Library Project

Description:
To be used on a recordset like a QoQ. Mimics MySQL's Limit function i.e. SELECT * FROM myTable LIMIT 0, 10 The above code will display the first 10 results from your table SELECT * FROM myTable LIMIT 5, 5 Starting from the 5th record this will bring back rows 5, 6, 7, 8, and 9. This functions aims to mimic this.

Return Values:
Returns a query.

Example:

<cfset qry = yourQuery />
<!--- Return rows 5-10 --->
<cfset newQuery = limit(qry, 5,5) />

Parameters:

Full UDF Source:

<!---
 Mimics MySQL limit's function.
 v2 mods by Raymond Camden and Steven Van Gemert
 
 @param inQry 	 Query to modify. (Required)
 @param arg1 	 Row to begin the limit. (Required)
 @param arg2 	 Number of rows to limit the result to. (Required)
 @return Returns a query. 
 @author Andy Jarrett (&#109;&#97;&#105;&#108;&#64;&#97;&#110;&#100;&#121;&#106;&#97;&#114;&#114;&#101;&#116;&#116;&#46;&#99;&#111;&#46;&#117;&#107;) 
 @version 2, February 13, 2009 
--->
<cffunction name="limit" returntype="query" description="WORKS LIKE MYSQL LIMIT(N,N)" output="false">
	<cfargument name="inQry" type="query" hint="I am the query" />
	<cfargument name="arg1" type="numeric" />
	<cfargument name="arg2" type="numeric" />
    
	<cfscript>
	var outQry = arguments.inQry;
	var a1 = arguments.arg1-1;
	
	if(arg1 GT 1){
	    outQry.RemoveRows(JavaCast( "int", 0 ), JavaCast( "int", a1 ));
	}
	
	outQry.RemoveRows(JavaCast( "int", arg2 ),JavaCast( "int", outQry.recordcount-arg2));
	
	return outQry;
	</cfscript>
</cffunction>