Skip to main content
2Charlie
2Charlie
Inspiring
October 6, 2016
Answered

How to grab data through nested loops?

  • October 6, 2016
  • 1 reply
  • 596 views

The problem seems to be that it never gets inside the loop in line 13. I'm not sure if that line of code is correct because it's giving me Error in custom script module before it gets inside the loop. I put a plain texts inside the loop and it never gets executed.

<cfoutput>
    <cfset cfData = DeserializeJSON(artDetails)>
    <cfif structKeyExists(cfData, 'data')>
    <cfif not ArrayIsEmpty(cfData.data) >
        <cfloop index="i" from="1" to="#arrayLen(cfData.data)#">
            <!---<cfdump var="#cfData.data.faqChildren.categories#" >--->
            <cfdump var="#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45#" >
            <!---<cfdump var="#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.object#" >--->
            <h2>#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.object.name.en#(#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subCount#)</h2>
            <p>url_hash: #cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.object.url_hash#</p>
            <cfdump var="#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent#" >
            <ul>
                <cfloop index="p" from="1" to="#arrayLen(cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent)#" >
                    <li>#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent
.object.name#</li>
                </cfloop>
            </ul>
        </cfloop>
        <cfelse>
        <p>No data found for <b>#hash#</b>.
        <p>
    </cfif>
    </cfif>
</cfoutput>

My dump of subcontent at line 11 shows the following and I want to get the name. Any help is much appreciated.

This topic has been closed for replies.
Correct answer 2Charlie

Okay, so I have a structure instead of an array. How do I retrieve all the name from this structure? I don't want to manually specify each ID in the dot notation to access the value. There must be some more efficient ways to retrieve all the data within a struct.


Okay, I found the answer to my question. Replace line 13-15 with the following and now it's giving me the name that I need.

<cfloop collection="#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent#" item="id">
<li>Cell Name: #cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent[id].object.name#</li>
</cfloop>

1 reply

2Charlie
2CharlieAuthor
Inspiring
October 6, 2016

Okay, I've narrowed down the issues but not sure why it's still having issues.

<cfdump var="#cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent#" >

<p>Length: #arrayLen(cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subcontent)# </p>

The dump shows the following so I think there is an array but the output length shows the "Error in custom script module". Any thoughts?

2Charlie
2CharlieAuthor
Inspiring
October 6, 2016

I did an IsArray(cfData.data.faqChildren.categories.5798bea791121cc46fd77a45.subconten) and it says no. So, if it's not an array then what is it based on the image I've uploaded above?

2Charlie
2CharlieAuthor
Inspiring
October 6, 2016

Okay, so I have a structure instead of an array. How do I retrieve all the name from this structure? I don't want to manually specify each ID in the dot notation to access the value. There must be some more efficient ways to retrieve all the data within a struct.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices