Ask Ben: Query Loop Inside CFScript Tags 

<!--- Create a new query. --->
<cfset qPornStars = QueryNew( "name, sex, preferred_category" ) />
 
<!--- Add rows to this query. --->
<cfset QueryAddRow( qPornStars ) />
<cfset qPornStars[ "name" ][ 1 ] = "Jenna Jameson" />
<cfset qPornStars[ "sex" ][ 1 ] = "Female" />
<cfset qPornStars[ "preferred_category" ][ 1 ] = "Girl on Girl" />
 
<cfset QueryAddRow( qPornStars ) />
<cfset qPornStars[ "name" ][ 2 ] = "Peter North" />
<cfset qPornStars[ "sex" ][ 2 ] = "Male" />
<cfset qPornStars[ "preferred_category" ][ 2 ] = "Guy on Girl" />

For Cut-and-Paste