TryCF Gist

trycf-gist.cfm

<cfscript>

myCountry = "China";

peopleInChina = queryExecute(
    "SELECT * FROM people WHERE country = :country",
    {country: myCountry},
    {dbType:"query", maxrows:1}
);



writeDump({
    "1: by struct": deSerializeJSON(
            serializeJSON( peopleInChina, 'struct' ) 
        ),
    
    "2: by row": deSerializeJSON(
            serializeJSON( peopleInChina, 'row' ) 
        ),
    
    "3: by column": deSerializeJSON(
            serializeJSON( peopleInChina, 'column' ) 
        )
});

</cfscript>