TryCF Gist

trycf-gist-1769762448745-10855af6-f724-a1b2-9082-d235db3658af.cfm

<cfscript>
idList = "A1,A2,B1,B4,C6,A1,A2,B1,B4,C6";

writeOutput("Lista di id: #idList#<hr>");


writeOutput("Codice originale");

queryObj = queryNew("IDCODICE","VarChar");
for (item in listToArray(idList)) {
  qcr = queryAddRow(queryObj);
  querySetCell(queryObj, "IDCODICE", item, qcr);
}

writeDump(var=queryObj, label="queryObj");

writeOutput("<hr>Con for senza querySetCell");

queryObj2 = queryNew("IDCODICE","VarChar");
for (item in listToArray(idList)) {
  queryAddRow(queryObj2, {"IDCODICE" = item});
}

writeDump(var=queryObj2, label="queryObj");
</cfscript>