TryCF Gist

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

<cfscript>
idList = "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<br/>");

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

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

queryObj3 = queryNew("IDCODICE","VarChar");
ids = listToArray(idList);
for (id in ids) {
  queryAddRow(queryObj3, {"IDCODICE" = id});
}

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