<!--- Create query to ouptut to excel. --->
<cfset qMovie = QueryNew(
	"id, name, date_watched, rating, has_fighting, has_boobies",
	"CF_SQL_INTEGER, CF_SQL_VARCHAR, CF_SQL_DATE, CF_SQL_DECIMAL, CF_SQL_BIT, CF_SQL_BIT"
	) />
 
<!--- Add rows to query. --->
<cfset QueryAddRow( qMovie, 5 ) />
 
<!--- Set row data. --->
<cfset qMovie[ "id" ][ 1 ] = JavaCast( "int", 1 ) />
<cfset qMovie[ "name" ][ 1 ] = JavaCast( "string", "Terminator 2" ) />
<cfset qMovie[ "date_watched" ][ 1 ] = JavaCast( "float", "2006/05/25" ) />
<cfset qMovie[ "rating" ][ 1 ] = JavaCast( "float", 10.0 ) />
<cfset qMovie[ "has_fighting" ][ 1 ] = JavaCast( "boolean", true ) />
<cfset qMovie[ "has_boobies" ][ 1 ] = JavaCast( "boolean", false ) />
 
<cfset qMovie[ "id" ][ 2 ] = JavaCast( "int", 2 ) />
<cfset qMovie[ "name" ][ 2 ] = JavaCast( "string", "American Pie" ) />
<cfset qMovie[ "date_watched" ][ 2 ] = JavaCast( "float", "2005/08/02" ) />
<cfset qMovie[ "rating" ][ 2 ] = JavaCast( "float", 9.0 ) />
<cfset qMovie[ "has_fighting" ][ 2 ] = JavaCast( "boolean", false ) />
<cfset qMovie[ "has_boobies" ][ 2 ] = JavaCast( "boolean", true ) />
 
<cfset qMovie[ "id" ][ 3 ] = JavaCast( "int", 3 ) />
<cfset qMovie[ "name" ][ 3 ] = JavaCast( "string", "Friends With Money" ) />
<cfset qMovie[ "date_watched" ][ 3 ] = JavaCast( "float", "2006/06/21" ) />
<cfset qMovie[ "rating" ][ 3 ] = JavaCast( "float", 8.0 ) />
<cfset qMovie[ "has_fighting" ][ 3 ] = JavaCast( "boolean", false ) />
<cfset qMovie[ "has_boobies" ][ 3 ] = JavaCast( "boolean", false ) />
 
<cfset qMovie[ "id" ][ 4 ] = JavaCast( "int", 4 ) />
<cfset qMovie[ "name" ][ 4 ] = JavaCast( "string", "Better Than Chocolate" ) />
<cfset qMovie[ "date_watched" ][ 4 ] = JavaCast( "float", "2006/10/07" ) />
<cfset qMovie[ "rating" ][ 4 ] = JavaCast( "float", 8.5 ) />
<cfset qMovie[ "has_fighting" ][ 4 ] = JavaCast( "boolean", true ) />
<cfset qMovie[ "has_boobies" ][ 4 ] = JavaCast( "boolean", true ) />
 
<cfset qMovie[ "id" ][ 5 ] = JavaCast( "int", 5 ) />
<cfset qMovie[ "name" ][ 5 ] = JavaCast( "string", "Real Genius" ) />
<cfset qMovie[ "date_watched" ][ 5 ] = JavaCast( "float", "2006/12/12" ) />
<cfset qMovie[ "rating" ][ 5 ] = JavaCast( "float", 9.0 ) />
<cfset qMovie[ "has_fighting" ][ 5 ] = JavaCast( "boolean", false ) />
<cfset qMovie[ "has_boobies" ][ 5 ] = JavaCast( "boolean", false ) />