Search code examples
arrayscoldfusionstructurecoldfusion-9

Coldfusion - how to convert one structure to an array


I am helping a friend with a Coldfusion issue, I am just having difficulty with a simple problem. We are trying to obtain the column names coming from a SQL table and the way we do that is by doing the following:

Now we are trying to get the same info but from an Array of Structures (see screen shot attached here).

enter image description here

    <cfdump var="#ApiData#">
    <cfset numColumns = StructCount(ApiData[1])>
    <cfdump var="#numColumns#">
    <cfdump var="#ApiData[1].Created#">
    <cfabort>

    <cfloop from="1" to="#numColumns#" index="i">   
        <cfset ColumnNames = ?how do I create an array of columns here?
    </cfloop>

Thank you


Solution

  • So you want an array of ["Created", "CreatedBy", etc] ?

    That's just:

    structKeyArray(nameOfStruct);
    

    You don't need the loop.

    Docs: structKeyArray()