ColdFusion / CFML : get a query containing the desired row data.

getQueryRow.cfm

<cfscript>
/**
* @param qry 	The query containing the desired data (required)
* @param row 	The desired row number (optional)
* @return Returns a query containing the desired row data
*/
public query function getQueryRow(required query qry, numeric row) {
	var requestedRow = StructKeyExists(arguments, 'row') ? arguments.row : arguments.qry.currentrow;
	var rs = QueryNew(arguments.qry.columnList);
	QueryAddRow(rs);
	for ( var col in ListToArray(arguments.qry.columnList) ) {
		QuerySetCell(rs, col, arguments.qry[col][requestedRow]);
	}
	return rs;
}
</cfscript>