<!--- Create an empty query. ---> <cfset qGirl = QueryNew( "" ) /> <!--- Add columns to this empty query and provide default column values. ---> <cfset QueryAddColumn( qGirl, "name", "CF_SQL_VARCHAR", ListToArray( "Libby,Kit,Sam,Niki" ) ) /> <cfset QueryAddColumn( qGirl, "hair", "CF_SQL_VARCHAR", ListToArray( "Blonde,Blonde,Blonde,Brunetted" ) ) /> <cfset QueryAddColumn( qGirl, "age", "CF_SQL_INTEGER", ListToArray( "28,24,25,27" ) ) />