TryCF Gist

trycf-gist-1539966701082-a36451e9-a0a5-0b16-c10c-e2707bb011b4.cfm

<cfscript>
    // Define our query 
    platform = ["Adobe ColdFusion", "Railo", "Lucee"]; 
    myQuery = queryNew(" "); 
    queryAddColumn(myQuery, "platform", "CF_SQL_VARCHAR", platform); 
    
    
    // By row index 
    writeOutput("<h3>By row:</h3>");
    for (i = 1; i <= myQuery.recordCount; i++) { 
       writeOutput("<li>#myQuery["platform"][i]#</li>"); 
    } 
    
    
    // By query 
    writeOutput("<h3>By query:</h3>");
    for (row in myQuery) { 
       writeOutput("<li>#row.platform#</li>"); 
    }


    // By arrayeach 
    writeOutput("<h3>By arrayeach:</h3>");
    function printArray(vendor, index)
    {
        writeOutput("<li>#vendor#</li>");
    }
    arrayEach(platform,printArray);
</cfscript>