CF2025 qoq aggregate functions shows empty string instead of null
Hi All,
We are migrating from Cf2021 to CF2025.
One issue is that QoQ resuts shows empty string when is not data.
<cfscript>
tempQuery = queryNew("id,name,amt", "integer,varchar,double");
QueryAddRow(tempQuery);
QuerySetCell(tempQuery, "id", 1);
QuerySetCell(tempQuery, "name", "Marco");
QuerySetCell(tempQuery, "amt", 16);
QueryAddRow(tempQuery);
QuerySetCell(tempQuery, "id", 2);
QuerySetCell(tempQuery, "name", "Troy");
QuerySetCell(tempQuery, "amt", 7);
result = queryExecute(
"SELECT SUM(amt) AS cnt FROM tempQuery",
{},
{dbtype="query"}
);
writeDump(result);
writeDump(result.recordcount());
result = queryExecute(
"SELECT SUM(amt) AS cnt FROM tempQuery where id = 3",
{},
{dbtype="query"}
);
writeDump(result);
writeDump(result.recordcount());
</cfscript>Result

The record count now is 1 for empty QoQ. It shoud be zero.
Any solution on this issue?
Thanks,
JFB
