Coldfusion - How to loop through an Array of Structure and print out dynamically all KEY values?

Question

Giving the Array of Structure below:

enter image description here

I am able to print out all values from all fields by doing:

    <cfset ColumnNames  = structKeyArray(ApiData[1])>                       
    <cfset ColumnLength = ArrayLen(ColumnNames)>    

    <cfloop from="1" to="#ArrayLen(ApiData)#" index="i">            
       <cfdump var="#ApiData[i].Created#">              
       <cfdump var="#ApiData[i].Name#">
               ...and so on

Now I am trying to loop through all fields so that I dont have to actually write the name of each field. How do I do this dynamically? Something like:

    <cfloop from="1" to="#ArrayLen(ApiData)#" index="i">    
      <cfloop from="1" to="#ColumnLength#" index="i">
              <!---<cfdump var="#ApiData[i]." + "#ColumnNames[i]#" + "#">--->
              <!---<cfdump var="#ApiData[i].ColumnNames[i]#">--->
      </cfloop>
    </cfloop>

I am not a ColdFusion guy, just helping a buddy and the ColdFusion syntax is very different from .Net :-)

Thank you for your help

My vote on this question should get your reputation into 3 digits. You owe me a beer. — Dan Bracuk
– Dan Bracuk, Commented Nov 1, 2013 at 11:45

Fergus · Accepted Answer · 2014-07-08 04:09:43Z

24

<cfloop from="1" to="#arrayLen(ApiData)#" index="i">
  <cfset data = ApiData[i]>
  <cfloop collection="#data#" item="key">
    #key#:#data[key]#
  </cfloop> 
</cfloop>

Or you can use CFScript, which should be much easier to pick up.

for (d in ApiData)  // for-in loop for array
{
  for (key in d)  // for-in loop for struct
  {
     writeOutput(key & ":" & d[key]);
  }
}

use this link: http://www.learncfinaweek.com/week1/Looping/

edited Jul 8, 2014 at 4:09

Fergus

2,9822 gold badges29 silver badges42 bronze badges

answered Nov 1, 2013 at 1:49

Henry

33k23 gold badges128 silver badges227 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Leigh Over a year ago

@Max - Since you did not mention the CF version, be aware that for-in-loops with arrays requires CF9.0.1+.

Max Over a year ago

That did not work. It seems that your solution applies to a single structure. Remember, I have to loop through an Array of Structures. I tried accessing the first structure of the Array by doing the following: <cfloop collection="#ApiData[1]#" item="key"> #key#:#ApiData[key]# </cfloop> I am using CF 8 by the way -- thanks

Max Over a year ago

I changed to: <cfdump var="#ApiData[1][key]#"> and it actually worked. Now all I need is to make it dynamic - thank you!

Henry Over a year ago

@Max hmm, sorry didn't know you're still in CF8. I've updated the CFML answer and it should work for you.

Collectives™ on Stack Overflow

Coldfusion - How to loop through an Array of Structure and print out dynamically all KEY values?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related