Create a list in a loop

Question

I am trying to create a comma separated list inside a loop, but I think I am missing something. When I dump item_id_list, I just get items separated by a space - not a comma. Can anyone point what am I missing?

<cfloop array="data" index="doc">
    <cfif structKeyExists(doc, "id") >
        <cfset the_item_id = doc.id /> 
    </cfif>
  <cfset item_id_list = ''/>
  <cfset item_id_list = listappend(item_id_list,'#the_item_id#',',')/>
</cfloop>

just get items separated by a space That could not happen with the code above, because it overwrites the list each time. You need to post the actual code causing the problem. — Leigh
– Leigh, Commented Jul 20, 2016 at 4:06

Community · Accepted Answer · 2016-07-20 06:14:31Z

10

Create the list outside of the loop:

<cfset item_id_list = "" />
<cfloop array="#data#" index="doc">
   <cfif structKeyExists(doc, "id") >
       <cfset item_id_list = listappend(item_id_list, doc.id, ",") />
   </cfif>
</cfloop>

edited Jul 20, 2016 at 6:14

CommunityBot

11 silver badge

answered Jul 13, 2016 at 16:51

Evik James

10.5k19 gold badges78 silver badges124 bronze badges

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

Comments

Shawn · Accepted Answer · 2016-07-19 14:18:55Z

0

Will this work?

<cfset item_id_list = ArrayToList(data.id)>

EDIT: Oops. Can't reference a struct in an array like that. Instead try:

<cfscript>
    item_id_list = "" ;
    for (row in data) {
        if (structkeyexists(row,"id") ) {
            item_id_list = listappend(item_id_list,row.id) ;
        }
    }
</cfscript>

For loops like this, cfscript syntax is easier to see.

edited Jul 19, 2016 at 14:18

answered Jul 18, 2016 at 21:18

Shawn

4,7861 gold badge22 silver badges29 bronze badges

Collectives™ on Stack Overflow

Create a list in a loop

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related