Ask Ben: Converting A Struct To A Query (And More Java)

<!--- Create a query of body parts. --->
<cfset qParts = QueryNew( 
	"id, name, turn_on",
	"INTEGER, VARCHAR, VARCHAR"
	) />
 
<!--- Add rows to the query. --->
<cfset QueryAddRow( qParts, 7 ) />
 
<!--- Set row data. --->
<cfset qParts[ "id" ][ 1 ] = 1 />
<cfset qParts[ "name" ][ 1 ] = "Feet" />
<cfset qParts[ "turn_on" ][ 1 ] = "No" />
 
<cfset qParts[ "id" ][ 2 ] = 2 />
<cfset qParts[ "name" ][ 2 ] = "Calves" />
<cfset qParts[ "turn_on" ][ 2 ] = "Yes" />
 
<cfset qParts[ "id" ][ 3 ] = 3 />
<cfset qParts[ "name" ][ 3 ] = "Thighs" />
<cfset qParts[ "turn_on" ][ 3 ] = "Yes" />
 
<cfset qParts[ "id" ][ 4 ] = 4 />
<cfset qParts[ "name" ][ 4 ] = "Butt" />
<cfset qParts[ "turn_on" ][ 4 ] = "Very Much" />
 
<cfset qParts[ "id" ][ 5 ] = 5 />
<cfset qParts[ "name" ][ 5 ] = "Hands" />
<cfset qParts[ "turn_on" ][ 5 ] = "Yes" />
 
<cfset qParts[ "id" ][ 6 ] = 6 />
<cfset qParts[ "name" ][ 6 ] = "Smile" />
<cfset qParts[ "turn_on" ][ 6 ] = "Yes" />
 
<cfset qParts[ "id" ][ 7 ] = 7 />
<cfset qParts[ "name" ][ 7 ] = "Hair" />
<cfset qParts[ "turn_on" ][ 7 ] = "No" />

For Cut-and-Paste