TryCF Gist

trycf-gist-1662536255458-2a5de9e2-93f5-da6e-0221-f67c67bac2b0.cfm

<cfscript>
function getDataTypeFrpmQuery(qry) {
    var rows=queryRecordcount(qry);
    loop array=queryColumnArray(qry) item="local.col" {
        loop from=1 to=rows index="local.row" {
            dump(label:col&":"&row,var:qry[col][row]);
        }
    }
}

qry=query(
    string:["String","123.0"]
    ,double:[123,123.456]
    ,int:[CreateObject("java","java.lang.Integer").parseInt("222"),CreateObject("java","java.lang.Integer").parseInt("222")]
    ,float:[CreateObject("java","java.lang.Float").parseFloat("333"),CreateObject("java","java.lang.Float").parseFloat("333.0")]
    ,bd:[CreateObject("java","java.math.BigDecimal").TEN,CreateObject("java","java.math.BigDecimal").valueOf(123)]
);
dump(qry);
getDataTypeFrpmQuery(qry);
</cfscript>