<!--- Create movie query. --->
<cfset qMovie = QueryNew(
	"name",
	"CF_SQL_VARCHAR"
	) />
 
<!--- Add movie rows. --->
<cfset QueryAddRow( qMovie, 10 ) />
 
<!--- Set query data. --->
<cfset qMovie[ "name" ][ 1 ] = "Terminator" />
<cfset qMovie[ "name" ][ 2 ] = "Terminator 2" />
<cfset qMovie[ "name" ][ 3 ] = "Terminator 3" />
<cfset qMovie[ "name" ][ 4 ] = "Predator" />
<cfset qMovie[ "name" ][ 5 ] = "Twins" />
<cfset qMovie[ "name" ][ 6 ] = "Read Head" />
<cfset qMovie[ "name" ][ 7 ] = "True Lies" />
<cfset qMovie[ "name" ][ 8 ] = "Eraser" />
<cfset qMovie[ "name" ][ 9 ] = "Kindergarten Cop" />
<cfset qMovie[ "name" ][ 10 ] = "Pumping Iron" />
 
<!--- Select the movies. --->
<cfquery name="qSubMovie" dbtype="query">
	SELECT
		name
	FROM
		qMovie
	ORDER BY
		name ASC
</cfquery>
 
 
<!---
	Get the TOP 3 movies. We only need to do this if the
	record set is GREATER than 3 records long.
--->
<cfif (qSubMovie.RecordCount GT 3)>
 
	<!---
		Remove all rows beyond 3 (index 3 and
		greater from the Java stand point).
	--->
	<cfset qSubMovie.RemoveRows(
		JavaCast( "int", 3 ),
		JavaCast( "int", qSubMovie.RecordCount - 3 )
		) />
 
</cfif>