How can I write a cfloop with dynamic index from file upload

Question

I have the following code that is reading a spreadsheet in a file upload. My question is: How do i make COL_3 dynamic so the 3 is the index number of the loop? So something like:

<cfset test = test & variables.file.COL_[j][j]>

but this doesnt work. This is what I have:

<cfset ColQty  = #ListLen(variables.file.ColumnList)#>
<cfset test = "">
  <cfloop from="1" to="#ColQty#" index="j">
      <cfset test = test & variables.file.COL_3[j]>     
  </cfloop>

Any help appreciated. Thanks JC

Joe C · Accepted Answer · 2013-04-08 14:42:58Z

4

You can access struct keys like this:

<cfset test = test & variables.file["COL_" & j][j]>

But I expect your code will behave incorrectly since you're not resetting test each time, so it will just keep appending over and over.

answered Apr 8, 2013 at 14:42

Joe C

3,5462 gold badges23 silver badges32 bronze badges

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

1 Comment

jeeperscreepers Over a year ago

Thanks that works fine, thats ok I need to build a list for the test variable value.

Jason Dean · Accepted Answer · 2013-04-08 14:47:32Z

2

I think you are looking for something like this.

<cfloop from="1" to="#ColQty#" index="j">
    <cfset test = test & variables.file["COL_" & j][j]>     
</cfloop>

edited Apr 8, 2013 at 14:47

answered Apr 8, 2013 at 14:42

Jason Dean

9,62529 silver badges39 bronze badges

1 Comment

jeeperscreepers Over a year ago

I now see this error when i apply your suggestion: Complex object types cannot be converted to simple values.

Collectives™ on Stack Overflow

How can I write a cfloop with dynamic index from file upload

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related