querySlice

Returns a query containing a subset of another query

querySlice(query, offset [, length]) → returns query

Member Function Syntax

query.slice(offset [, length])

  1. CFDocs
  2. Functions
  3. Query Manipulation Functions
  4. querySlice
  5. CF2018.0.5+
  6. Lucee
  7. 0 Issue
  8. Edit

Argument Reference

query query
Required

offset numeric
Required

The first row to include in the new query

length numeric

The number of rows to include in the new query, defaults to all remaining rows

Examples
Sample code invoking the querySlice function 

data = [
	[ 1,'James' ],
	[ 2,'Alfred' ],
	[ 3,'Amisha' ],
	[ 4,'Terri' ]
];
myQuery = QueryNew( 'ID,name','integer,varchar',data );
result = QuerySlice( myQuery,2,2 );
writeDump( var='#result#' );

data = [
	[ 1,'James' ],
	[ 2,'Alfred' ],
	[ 3,'Amisha' ],
	[ 4,'Terri' ]
];
myQuery = QueryNew( 'ID,name','integer,varchar',data );
result = myQuery.slice( 2,2 );
writeDump( var='#result#' );

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub