TryCF Gist

trycf-gist-1588011662070-a30a56e3-b3f0-6c9c-f6e7-73cb025c508e.cfm

<cfscript>
// CFScript version
fResult = QueryNew("factor_id,factor_name","integer,varchar");

names = "one,two,three";
for (id = 1; id <= 3; id++) {
QueryAddRow(fResult, 1);
QuerySetCell(fResult, "factor_id", id, id);
QuerySetCell(fResult, "factor_name", ListGetAt(names, id), id);
}
</cfscript>

<!--- <cfset fResult["factor_name"] = "factor_name"> --->
<cfdump var = "#fResult#">

<!---
    <cfloop query="fResult">
    <cfset fResult["factor_id"] = factor_id>
    <cfset fResult["factor_name"] = factor_name>

    </cfloop>

<cfdump var = "#fResult#">

--->