TryCF Gist

trycf-gist-1635388543607-349bd2de-903f-b856-a0d4-a8fc586baa42.cfm

<cfscript>

    local.results = queryNew( "Name,Title", "varchar,varchar" );
    
    queryAddRow( local.results );
    querySetCell( local.results, "Name", "Mark" );
    querySetCell( local.results, "Title", "Developer" );
    
    queryAddRow( local.results );
    querySetCell( local.results, "Name", "Jessica" );
    querySetCell( local.results, "Title", "Manager" );
    
    queryAddRow( local.results );
    querySetCell( local.results, "Name", "Alisha" );
    querySetCell( local.results, "Title", "Designer" );
    
    writeDump( local.results );
    
    for ( local.row in local.results ) {
        writeOutput( "#local.results.Name# is a #local.results.Title#<br/>" );
    }

</cfscript>